UPSC CDS - Advance DBMS 1000+ MCQ [Solved] PDF Download

1. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key
Answer : C

2. The control of concurrent execution is left with the
A. operating system
B. controller unit of the kernel
C. concurrency control component of the database system
D. none
Answer : C

3. What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
A. i, ii and iii only
B. i, ii and iv only
C. ii, iii and iv only
D. i, iii and iv only
Answer : B

4. which of the following is a binary operation?
A. project
B. select
C. rename
D. none of the above
Answer : D

5. Secondary storage
A. magnetic disk
B. magnetic tape
C. juke box
D. cache
Answer : A

6. A transaction is said to have terminated if it has
A. either committed or aborted
B. either partially committed or aborted
C. either committed or failed
D. none of these
Answer : D

7. Relational Algebra is
A. Data Definition Language.
B. Data Manipulation Language
C. Procedural query Language
D. None of the above
Answer : C

8. In an object oriented model, one object can access data of another object by passing?
A. Instance variable
B. Variable
C. Message
D. Function
Answer : C

9. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
A. mn
B. m+n
C. m+n)/2
D. 2 m+n)
Answer : A

10. Encoding method which does not provide for synchronization
A. B8ZS
B. Manchester
C. RZ
D. NRZ-L
Answer : D

11. Which of the following is logical topology?
A. Bus
B. Ring
C. Star
D. None of these
Answer : B

12. …………… is responsible for using that the database remains in a consistent state despite system failure.
A. Storage manager
B. Admin
C. Transaction manager
D. none of the above
Answer : C

13. .................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
A. Noise
B. Delay distortion
C. Attenuation distortion
D. Dispersion
Answer : B

14. The number of cursors depend on the
A. number of queries
B. number of attributes
C. size of memory area
D. none of these
Answer : C

15. As a side-effect of database update ,the system automatically executes a statement called
A. a view
B. a grant permission
C. a trigger
D. all of the above
Answer : C

16. The database environment has all of the following components except:
A. users.
B. separate files.
C. database.
D. database administrator.
Answer : A

17. Which command is used to cancel privileges granted through the GRANT command ?
A. CANCEL
B. OVER
C. STOP
D. REVOKE
Answer : D

18. Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
A. i and ii only
B. ii and iii only
C. i and iii only
D. i only
Answer : A

19. EEPROM
A. Electrically Extractable Programmable Read Only Memory
B. Electrically Erasable Programmable Read Only Memory
C. Electronically Erasable Programmable Read Only Memory
D. Electrically Erasable Programmable Read Only Memory
Answer : D

20. What is ACID properties of Transactions?
A. Atomicity, Consistency, Isolation, Database
B. Atomicity, Consistency, Isolation, Durability
C. Atomicity, Consistency, Inconsistent, Durability
D. Automatically, Concurrency, Isolation, Durability
Answer : B

21. FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
A. i and ii only
B. ii and iii only
C. i and iii only
D. iii and iv only
Answer : D

22. A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
A. i and ii only
B. ii and iii only
C. i and iii only
D. iii and iv only
Answer : D