Discussion Forum

Interative Forum for discussing any query literally to UGC-NET Computer Science, GATE Computer Science and Computer Sciene and Technology in general.

ugc_net image

UGC-NET Computer Science

Correspondence Courses and Test Series to prepare for UGC-NET computer science and applications

GATE image


MCQs, Lecture Notes, Ebooks for GATE preparation

freestuff image
jobs image

Jobs Newsfeed

Timely information of various Recruitments.


Answer Key and Solved Questions Paper-3 UGC-NET Computer Science June 2015

1.For the 8-bit word 00111001, the check bits stored with it would be 0111. Suppose when the word is read from memory, the check bits are calculated to be 1101.What is the data word that was read from memory?
View/Hide Ans
2.Consider a 32 - bit microprocessor, with a 16 - bit external data bus, driven by an 8 MHz input clock. Assume that the microprocessor has a bus cycle whose minimum duration equals four input clock cycles. What is maximum data transfer rate for this microprocessor ?
A.8 x 106 bytes / sec
B.4 x 106 bytes / sec
C.16 x 106 bytes / sec
D.4 x 109 bytes / sec
View/Hide Ans
3.The RST 7 instruction in 8085 microprocessor is equivalent to
A.CALL 0010 H
B.CALL 0034 H
C.CALL 0038 H
View/Hide Ans
4.The equivalent hexadecimal notation for octal number 2550276 is:
View/Hide Ans
5.The CPU of a system having 1 MIPS execution rate needs 4 machine cycles on an average for executing an instruction. The fifty percent of the cycles use memory bus. A memory read/write employs one machine cycle. For execution of the programs, the system utilizes 90 percent of the CPU time. For block data transfer, an IO device is attached to the system while CPU executes the background programs continuously. What is the maximum IO data transfer rate if programmed IO data transfer technique is used?
A.500 Kbytes/sec
B.2.2 Mbytes/sec
C.125 Kbytes/sec
D.250 Kbytes/sec
View/Hide Ans
6.The number of Flip-Flops required to design a modulo - 272 counter is
View/Hide Ans
7.Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many - many. R1 and R2 donot have any attributes of their own. How many minimum number of tables are required to represent this situation in the relational model ?
View/Hide Ans
8.The student information in a university is stored in the relation STUDENT (name, sex, marks, dept_Name) Consider the following SQL query select deptName from STUDENT where sex = 'M' group by dept_Name having avg (marks) > (select avg (marks) from STUDENT) It returns the names of the department in which
A.the average marks of male students is more than the average marks of the students in the same department
B.The average marks of male students is more than the average marks of the students in the university
C.The average marks of male students is more than the average marks of male students in the university
D.The average marks of students is more than the average marks of male students in the university
View/Hide Ans
9.Which one of the following statements about normal forms is FALSE?
A.Lossless, preserving decomposition into 3NF is always possible
B.Lossless, preserving decomposition into BCNF is always possible
C.Any relation with two attributes is in BCNF
D.BCNF is stronger than 3NF
View/Hide Ans
10.The relation vendor order (v_no, v_ord_no, v_name, qty_sup, unit_price) is in 2NF because :
A.Non key attribute V_name is dependent on V_no which is part of composite key
B.Non key attribute V_name is dependent on qty_sup
C.key attribute qty_sup is dependent on primary_key unit price
D.key attribute v_ord_no is dependent on primary_key unit price
View/Hide Ans

Author Does Not claim of any answer these answers are as per expert opinion

Pages: 1 2 3 4 5 6