DBMS Quiz



DBMS Quiz at csepedia.org

1. E-R model uses this symbol to represent weak entity set

A. Dotted rectangle
B. Diamond
C. Doubly outlined rectangle
D. None of these


2. Architecture of the Database can be viewed as

A. Two levels
B. Three levels
C. Four levels
D. One level


3. If a transaction T has obtained an exclusive lock on item Q, then T can

A. Read Q
B. Write Q
C. Both Read and Write Q
D. Write Q but not Read Q


4. The method of access which uses key transformation is known as

A. Direct
B. Hash
C. Random
D. Sequential


5. A function that has no partial functional dependencies is in __________ form.

A. 2 NF
B. 3 NF
C. 4 NF
D. BCNF


6. Locking was introduced into database so that

A. Keys can be provided to maintain security.
B. All simultaneous transactions are prevented.
C. Passwords can be provided to maintain security.
D. Consistency can be enforced.


7. Which of the following is an advantage of view?

A. Data security
B. Derived columns
C. Hiding of complex queries
D. All of the above


8. An Entity set that does not have sufficient attributes to form a primary key is a

A. Strong entity set
B. Weak entity set
C. Simple entity set
D. Primary entity set


9. The result of the UNION operation between R1 and R2 is a relation that includes

A. All the tuples of R1
B. All the tuples of R2
C. All the tuples of R1 and R2
D. All the tuples of R1 and R2 which have common columns


10. ODBC stands for

A. Object Database Connectivity
B. Oral Database Connectivity
C. Open Database Connectivity
D. Oracle Database Connectivity


11. The Database Schema is written in

A. HLL
B. DML
C. DDL
D. DCL


12. The Entity Relationship model comes under

A. Object based logical model
B. Record based logical model
C. Physical data model
D. None of the above


13. The DBMS language component which can be embedded in a program is

A. The Data Definition Language
B. The Data Manipulation Language
C. The Database Administrator
D. A query Language


14. Relational Calculus is a

A. Procedural language
B. Non Procedural language
C. Data Definition language
D. High level language


15. Which of the following is not a DCL statement?

A. ROLLBACK
B. GRANT
C. REVOKE
D. None of these




CSE Quiz

Algorithms




Database Management




C++ Quiz 1

C++ Quiz 2




Digital Electronics





Data Structures




Computer Architecture




Computer Network




HTML





Automata Theory




Operating System