Thursday, 3 March 2016

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 back to DBMS Quizzes/MCQs page






No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...