Computer Science Study Materials for Competitive Exams


Wednesday, 25 January 2017

CBSE UGC NET Computer Science Paper III Solved January 2017 - Part 1

1.       Which of the following is an interrupt according to temporal relationship with system clock?
(1) Maskable interrupt
(2) Periodic interrupt
(3) Division by zero
(4) Synchronous interrupt
Answer: 4
2.       Which of the following is incorrect for virtual memory?
(1) Large programs can be written
(2) More I/O is required
(3) More addressable memory available
(4) Faster and easy swapping of process
Answer: 2
3.       The general configuration of the microprogrammed control unit is given below:
What are blocks B and C in the diagram respectively?
(1) Block address register and cache memory
(2) Control address register and control memory
(3) Branch register and cache memory
(4) Control address register and random access memory
Answer: 2
4.       Match the following:
Addressing Mode      Location of operand
a. Implied                      i. Registers which are in CPU
b. Immediate                 ii. Register specifies the address
of the operand
c. Register                     iii. Specified in the register
d. Register Indirect      iv. Specified implicitly in the
definition of instruction
     a   b   c  d
(1) iv  iii   i   ii
(2) iv  i    iii  ii
(3) iv  ii   i   iii
(4) iv  iii  ii   i
Answer: 1
5.       In 8085 microprocessor, the digit 5 indicates that the microprocessor needs
(1) -5 volts, +5 volts supply
(2) +5 volts supply only
(3) -5 volts supply only
(4) 5 MHz clock
Answer: 2

6.       In 8085, which of the following performs: load register pair immediate operation?
(1) LDAX rp
(2) LHLD addr
(3) LXI rp, data
(4) INX rp
Answer: 3
7.       Consider following schedules involving two transactions:
Which of the following statement is true?
(1) Both S1 and S2 are conflict serializable.
(2) S1 is conflict serializable and S2 is not conflict serializable.
(3) S1 is not conflict serializable and S2 is conflict serializable.
(4) Both S1 and S2 are not conflict serializable.
Answer: 3
8.       Which one is correct w.r.t. RDBMS?
(1) primary key super key candidate key
(2) primary key candidate key super key
(3) super key candidate key primary key
(4) super key primary key candidate key
Answer: 2
9.       Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows:
(1) pk(R2)→pk(R1)
(2) pk(R1)→pk(R2)
(3) pk(R2)→R1∩R2
(4) pk(R1)→R1∩R2
Answer: 2
10.    For a database relation R(A,B,C,D) where the domains of A,B,C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are:
The relation R is in ................
(1) First normal form but not in second normal form
(2) Both in first normal form as well as in second normal form
(3) Second normal form but not in third normal form
(4) Both in second normal form as well as in third normal form
Answer: 1


  1. Question 10 answer is 1 only.

    (AB) is the key and clearly both FDs are partial dependencies. So, the given relation is only in 1NF and not in 2NF.