Quiz - DBMS

Q.1 Which is not the component of database system?

A. Database
B. Users
C. Database Query
D. All of the above

Ans - C
Explanation - The database system can be divided into four components- Users, Database, DBMS, Database Application

Q.2 The database architecture which is used for User interface programs and application programs that run on the client side.

A. One tier architecture
B. Two tier architecture
C. Three tier architecture
D. Four tier architecture

Ans - B

Q.3 An interface that provides an API to allow client side program to call
the dbms.

A. ODBC
B. JDBC
C. OBDC
D. JBDC

Ans - A
Explanation - Open Database Connectivity



Q.4 Which architecture is commonly used architecture for web application?

A. One Tier Architecture
B. Two Tier Architecture
C. Three Tier Architecture
D. Four Tier Architecture

Ans - C
Explanation- In the three tier architecture middle layer known as application server which send partially processed data between the client and database server

Q.5 The database model in which entities are organised in graph and some entities can be accessed through several path.

A. Relational Model
B. Heirarchy Model
C. Network Model
D. None of the above

Ans - C

Q.6 The rule to define the requirement for the DBMS to become Relational database management system.

A. Boyce-Codd
B. E. F. Codd
C. G.F. Codd
D. B.E.Codd

Ans - B

Q.7 Number of Rules in Codd's 12 rules?

A. 11
B. 12
C. 13
D. 8.5

Ans - C

Q.8 Which is correct statement ?

A. A tuple and true relation both cannot have duplicate tuples.
B. A tuple cannot have duplicate tuples while a true relation have duplicate tuples
C. A tuple have duplicate tuples while true relation cannot have duplicate tuples
D. None of the above

Ans - C

Q. 9 Referential integrity constraints work on the concept of

A. Primary Key
B. Candiadate key
C. Super Key
D. Foreign key

Ans - D