Database management systems quiz questions with answers 1

DBMS quiz with answers / Database Management Systems Basics Quiz / DBMS Multiple choice questions

Quiz

1. The row/tuple of a relational table is called as an entity _________.
(a) Instance	(b) Attribute
(c) Model	(d) Relationship
2. Relational calculus is a ________
(a) Procedural language	(b) Non-Procedural language
(c) Data Definition language	(d) High level language
3. SQL is a _____________
(a) Procedural language	(b) Non-Procedural language
(c) Data Definition language	(d) High level language
4. Cartesian product (X) operation in relational algebra is ________
(a) an unary operator	(b) a binary operator
(c) both (a) and (b)	(d) not an operator
5. A database schema can be written in ________
(a) DML (Data Manipulation Language)	(b) DDL (Data Definition Language)
(c) DCL (Data Control Language)	(d) TCL (Transaction Control Language)
6. Which of the following is the advantage of relational database model?
(a) Structural dependence	(b) Conceptual complexity
(c) Complex database design	(d) Easier database design
7. A relational database management system is a single data repository in which data _______ is maintained.
(a) independence	(b) dependence
(c) complexity	(d) None of the above
8. Relational algebra is a _________
(a) Procedural language	(b) Non-Procedural language
(c) Data Definition language	(d) High level language
9. Which of the following is the external level of database architecture?
(a) Physical level	(b) Logical level
(c) View level	(d) All of the above
10. An entity set that does not have enough _________ to form a _______ is a weak entity set.
(a) attribute, primary key	(b) records, foreign key
(c) records, primary key	(d) attribute, foreign key

Go to ER modeling quiz page

Go back to DBMS Quizzes/MCQs page