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.
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
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