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)
