
Database Management System (DBMS MCQ) Multiple Choice Questions and Answers
1. DBA stands for
Answer : C
2. In ER diagram, the total participation by entities is represented as ______
Answer : D
3. The feature that database allows to access only certain records in database is ______
Answer : A
4. Which of the following is not a property of transactions?
Answer : B
5. Relational Algebra does not have
Answer : C
DBMS MCQ
6. Tree structure are used to store data in
Answer : C
7. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Answer : B
8. The rule that a value of a foreign key must appear as a value of some specific table is called a
Answer : A
9. In an ER diagram double lines indicate
Answer : A
10. Fifth Normal form is concerned with
Answer : C
DBMS MCQ
11. The metadata is created by the
Answer : C
12. When an ER diagram is mapped to tables, the representation is redundant for
Answer : B
13. If the closure of an attribute set is the entire relation then the attribute set is a
Answer : A
14. The keyword to eliminate duplicate rows from the query result in SQL is
Answer : C
15. The information stored in the catalog of a database is called
Answer : D
DBMS MCQ
16. The method of access which uses key transformation is known as
Answer : B
17. Data independence means
Answer : D
18. The statement in SQL which allows to change the definition of a table is
Answer : A
19. SET concept is used in
Answer : A
20. ______ produces the relation that has attributes of R1 and R2
Answer : A
Related Links
- Power Electronics MCQ
- C Programming MCQ
- Operating System MCQ
- Visual Basic MCQ
- JAVA MCQ
- System Maintenance MCQ
- Software Engineering MCQ
- Management (Common) MCQ
- System Software MCQ
- Computer Graphics MCQ
- Multimedia MCQ
- Data Structure MCQ
- Software Package MCQ
- Digital Electronics MCQ
- DBMS MCQ
- Ecommerce MCQ
- Web Technology MCQ