CS/IT MCQs

Solved Objective Questions of Database Management System set-8

Google+ Pinterest LinkedIn Tumblr

Here are the collections of solved objective questions of database management system. You will find MCQ questions about fundamental of DBMS, relational DBMS and database normalization.

1. ………………………. is the powerful language for working with RDBMS.
A) Embedded Programs
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

Read Next: MCQ on Fundamental of Database Management System (DBMS) set-9

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 5 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

Write A Comment