PGT Computer Science (Level-3), (HTET Practice MCQs) (Part-II)

Total Questions: 100

1. Synchronization is achieved by a timing device called a __________ which generates a periodic train of __________ .

Correct Answer: E. *

2. Serial access memories are useful in applications where

Correct Answer: D. None of these

3. What will be the output of the following logic diagram?

Correct Answer: C. x XOR y

4. The essential difference between traps and interrupts is

Correct Answer: B. traps are synchronous and interrupts are asynchronous with the program.

5. Consider the following ER diagram:

Correct Answer: A. 2

6. Consider the following schemas :

Branch = (Branch-name, Assets, Branch-city)
Customer = (Customer-name, Bank name, Customer-city)
Borrow = (Branch-name, loan number, customer account-number)
Deposit = (Branch-name, Account-number, Customer-name, Balance)
Using relational Algebra, the Query that finds customers who have balance more than 10,000 is _______

Correct Answer: A.

7. Find the false statement:

Correct Answer: C. Conceptual model is not accurate representation of "Universe of interest".

8. Consider the table

Correct Answer: B. Q. 2

9. Armstrong (1974) proposed systematic approach to derive functional dependencies. Match the following w.r.t. functional dependencies:

Codes:

 (a) (b) (c) (d)
 A. (iii) (ii) (iv) (i)
 B. (i) (iii) (iv) (ii)
 C. (ii) (i) (iii) (iv)
 D. (iv) (iii) (i) (ii)
Correct Answer: D.

10. Match the following:

          List-I                 List-II
 (a) Secondary Index (i) Functional Dependency
 (b) Non-procedural Query Language (ii) B-Tree
 (c) Closure of set of Attributes (iii) Relational Algebraic Operation
 (d) Natural JOIN (iv) Domain Calculus

Codes:

 (a) (b) (c) (d)
 A. (i) (ii) (iv) (iii)
 B. (ii) (i) (iv) (iii)
 C. (i) (iii) (iv) (ii)
 D. (ii) (iv) (i) (iii)
Correct Answer: D.