MCQ of Database Management System (DBMS) – Set 3

New set of MCQ Questions in the category of Database Management System (DBMS). As usual there are 10 Multiple Choice Questions related to Database Management System and four options for each questions and only one options is the correct answer. Correct answers of these MCQ Questions are given below of this MCQ Question set.

MCQ Questions of Database Management System

Multiple Choice Questions of Database Management Systems (DBMS)

3-1. Who proposed the relational model?
A. Bill Gates
B. E.F. Codd
C. Herman Hollerith
D. Charles Babbage

3-2. Set of premitted values of each attribute is called
A. Domain
B. Tuple
C. Relation
D. Schema

3-3. Which of the following in true regarding Null Value?
A. Null = 0
B. Null < 0 C. Null > 0
D. Null <> 0

3-4. Logical design of database is called
A. Database Instance
B. Database Snapshot
C. Database Schema
D. All of the above

3-5. Snapshot of the dta in the database at a given instant of time is called
A. Database Schema
B. Database Instance
C. Database Snapshot
D. All of the above

3-6. Which of the following is not Unary operation?
A. Select
B. Project
C. Rename
D. Union

3-7. Which of the following is not binary operation?
A. Union
B. Project
C. Set Difference
D. Cartesian Product

3-8. Which of the following is correct regarding Aggregate functions?
A. it takes a list of values and return a single values as result
B. it takes a list of values and return a list of values as result
C. it takes a single value and returns a list of values as result
D. it takes a single value and returns a single value as result

3-9. The Primary key must be
A. Non Null
B. Unique
C. Option A or B
D. Option A and B

3-10. A command to remove a relation from an SQL database
A. Delete table <table name>
B. Drop table <table name>
C. Erase table <table name>
D. Alter table <table name>


Click Here for Answers
1 – B / 2 – A / 3 – D / 4 – C / 5 – B / 6 – D / 7 – B / 8 – A / 9 – D / 10 – B

Incoming search terms:

  • dbms multiple choice questions with answers for gate
  • multiple choice question on relational data model
  • Gate questions on dbms
  • dbms mcq for gate exam
  • dbms permutations sets and relations mcqs
  • mcq on relational database management system with answers
  • gate database questions and solution
  • mcq question for dbms
  • gate database questions answers
  • which of the following is corrwct regardibg aggregate functions?

2 Responses to “MCQ of Database Management System (DBMS) – Set 3”

  1. S.R.A.Laksan 10 August 2014 at 10:53 PM

    Thanks you !!!!

  2. ilyas baloch 17 September 2014 at 11:30 PM

    i am studing in University of balochistan for the exam i need your website help plz send me MCQs question with Answer on my mail address.

Leave a Reply