Solved Objective Questions of Database Management System set-9


1. ............................ is the powerful language for working with RDBMS.

A) Embedded Programs
Objective Questions of Database Management System
Database Management System (Photo credit: Wikipedia)

B) Dynamic Programs

C) Query Language

D) Static Language Programs



2. The file in DBMS is called as .................. in RDBMS.

A) console

B) schema

C) table

D) object



3. In ..................... , we have a strict parent-child relationship only.



B) network databases

C) object oriented databases

D) relational databases



4. Which normal form is considered adequate for relational database design?

A) 2 NF

B) 3 NF

C) 4 NF

D) BCNF



5. What operator tests column for the absence of data?

A) IS NULL operator


C) LIKE operator

D) NOT operator



6. Which is proper subset designed to support views belonging to different classes of users in order to hide or protect information.

A) Schema

B) Sub-schema

C) Non-schema

D) Non-sub schema



7. Which contain information about a file needed by system programs for accessing file records?

A) File blocks

B) File operators

C) File headers

D) None of these



8. A .................... DBMS distributes data processing tasks between the workstation and network server.

A) Network

B) Relational


D) Hierarchical



9. The .................... refers to the way data is organized in and accessible from DBMS.

A) database hierarchy

B) data organization

C) data sharing




10. ................. is a statement that is executed automatically by the system.

A) trigger

B) assertion

C) durability

D) integrity constraint



Answers:


1. ............................ is the powerful language for working with RDBMS.

C) Query Language


2. The file in DBMS is called as .................. in RDBMS.

C) table


3. In ..................... , we have a strict parent-child relationship only.


A) hierarchical databases.


4. Which normal form is considered adequate for relational database design?

B) 3 NF


5. What operator tests column for the absence of data?

A) IS NULL operator


6. Which is proper subset designed to support views belonging to different classes of users in order to hide or protect information.

B) Sub-schema


7. Which contain information about a file needed by system programs for accessing file records?

C) File headers


8. A .................... DBMS distributes data processing tasks between the workstation and network server.

C) Client Server


9. The .................... refers to the way data is organized in and accessible from DBMS.

D) data model


10. ................. is a statement that is executed automatically by the system.

A) trigger

Get 1000's of DBMS MCQs as pdf E-Book on Free Download Now