Database MCQs With Solved Quiz Test

Past papers important MCQs of sql mcq. All database management system mcq questions with answers. Advanced database management system mcq database management system questions and answers. Solved database questions and answers MCQs.

Get Start Test Here!

You Scored:

Ranking:

DBMS Multiple Choice Questions With Answers

1. The----- operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple?

Intersection

Union

Join (Answer)

Select

 

2. The tuples of the relations can be of -------- order?

Same

Any (Answer)

Constant

Sorted

 

3. Using which language can a user request information from a database ?

Compiler

Structural

Query (Answer)

Relational

 

4. A -------- in a table represents a relationship among a set of values?

Column

Key

Row (Answer)

Entry

 

5. Student(ID, name, dept name, tot-cred) In this query which attribute form the primary key?

Name

Dept

Tot-cred

ID (Answer)

 

6. A Database Management System (DBMS) is?

Collection of programs to access data

All of the above (Answer)

Collection of interrelated data

Collection of data describing one particular enterprise

 

7. Which one of the following is a procedural language ?

Relational algebra (Answer)

Domain relational calculus

Query language

Tuple relational calculus

 

8. Which of the following is Database Language?

Data Definition Language

Query Language

Data Manipulation Language

All of the above (Answer)

 

9. Database ---------- , which is the logical design of the database, and the database -------,which is a snapshot of the data in the database at a given instant in time?

Instance, Schema

Schema, Instance (Answer)

Relation, Domain

Relation, Schema

 

10. He term attribute refers to a ----------- of a table?

Column (Answer)

Key

Record

Tuple

 

11. For each attribute of a relation, there is a set of permitted values, called the -------- of that attribute?

Relation

Set

Domain (Answer)

Schema

 

12. In an Entity-Relationship Diagram Rectangles represents?

Entity sets (Answer)

Database

Attributes

Tables

 

13. The term ------- is used to refer to a row?

Attribute

Tuple (Answer)

Instance

Field

 

14. Which of the following is a Data Model?

Relational data model

All of the above (Answer)

Object-Based data model

Entity-Relationship model

 

15. Course(course-id,sec-id,semester) Here the course-id,sec-id and semester are ---------- and course is a --------- ?

Relations, Attribute

Tuple, Relation

Tuple, Attributes

Attributes, Relation (Answer)