forum_image

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

GATE

MCQs, Lecture Notes, Ebooks for GATE preparation

freestuff image
jobs image

Jobs Newsfeed

Timely information of various Recruitments.

NextPrev

Answer Key and Solved Questions Paper-3 UGC-NET Computer Science July 2016

1.Which of the following is a sequential circuit?
A.Multiplexer
B.Decoder
C.Counter
D.Full adder
View/Hide Ans
Explanation
2.8085 microprocessor has ............. hardware interrupts.
A.2
B.3
C.4
D.5
View/Hide Ans
Explanation
3.Which of the following in 8085 microprocessor performs HL = HL + DE ?
A.DAD D
B.DAD H
C.DAD B
D.DAD SP
View/Hide Ans
Explanation
4.The Register that stores all interrupt requests is:
A.Interrupt mask register
B.Interrupt service register
C.Interrupt request register
D.Status register
View/Hide Ans
Explanation
5.The ............... addressing mode is similar to register indirect addressing mode, except that an offset is added to the contents of the register. The offset and register are specified in the instruction.
A.Base indexed
B.Base indexed plus displacement
C.Indexed
D.Displacement
View/Hide Ans
Explanation
6.In ............. method, the word is written to the block in both the cache and main memory, in parallel.
A.Write through
B.Write back
C.Write protected
D.Direct mapping
View/Hide Ans
Explanation
7.Which of the following statements concerning Object-Oriented databases is FALSE?
A.Objects in an object-oriented database contain not only data but also methods for processing the data.
B.Object-oriented databases store computational instructions in the same place as the data.
C.Object-oriented databases are more adapt at handling structures (analytical) data than relational databases.
D.Object-oriented databases store more types of data than relational databases and access that data faster.
View/Hide Ans
Explanation
8.In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify:
A.Inheritances
B.Fragments
C.Locations
D.Local formats
View/Hide Ans
Explanation
9.Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S:
I. ?A,B(R?S)
II. R??B(S)
III. R?(?A(R) ? ?B(S))
IV. ?A,R.B(R ? S) where R.B refers to the column B in table R.
One can determine that:
A.I, III and IV are the same query.
B.II, III and IV are the same query.
C.I, II and IV are the same query.
D.I, III and III are the same query.
View/Hide Ans
Explanation
10.Which of the following statements is TRUE?
D1: The decomposition of the schema R(A,B,C) into R1(A,B) and R2(A,C) is always lossless.
D2: The decomposition of the schema R(A,B,C,D,E) having AD?B, C?DE, B?AE, AE?C into R1(A,B,D) and R2(A,C,D,E) is lossless.
A.Both D1 and D2
B.Neither D1 and D2
C.Only D1
D.Only D2
View/Hide Ans
Explanation


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


Pages: 1 2 3 4 5 6 7 8