Solved Objective Questions of Database Management System set-9

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

A) Embedded Programs

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.

A) hierarchical databases.

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

B) ASSIGNMENT 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

C) Client Server

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

D) data model

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

Related Posts

 

• Solved MCQ of Database Management System (DBMS) Set - 1
• Solved MCQ of Database Management System (DBMS) Set - 2
• Solved MCQ of Database Management System (DBMS) Set - 3
• Solved MCQ of Database Management System (DBMS) Set - 4
• Solved MCQ of Database Management System (DBMS) Set - 5
• MCQ of Database Management System (DBMS) with answer set-6
• MCQ of Database Management System(DBMS) with answer set-7
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here