Advanced Database Management System - Tutorials and Notes: Database management systems quiz questions with answers 1

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents