DBMS Multiple Choice Question
Question 1. A relational database consists of a collection of ?
A
Tables
B
Fields
C
Records
D
Keys
Answer:
Question 2. A ..... in a table represents a relationship amount a set of values.
A
Column
B
Keys
C
Row
D
Entry
Answer:
Question 3. The term .... is used to refer to a row
A
Attribute
B
Tuple
C
Field
D
Instance
Answer:
Question 4. The term attribute refers to a .... of a table.
A
Record
B
Column
C
Tuple
D
Key
Answer:
Question 5. For each attribute of a relation, there is a set of permitted values, called the ..... of that attribute.
A
Domain
B
Relation
C
Set
D
Schema
Answer:
Question 6. Datbase ......, which is the logical design of the database and the database ...., which is a snapshot of the data in the database at a given time ?
A
Instance, Schema
B
Relation, Schema
C
Relation, Domain
D
Schema, Instance
Answer:
Question 7. Course (course_id , sec_id,semester) are ..... and course is a ......
A
Relation, Attribute
B
Attribute, Relation
C
Tuple,Relation
D
Tuple, Attribute
Answer:
Question 8. A Domain is atomic if elements of the domain are considered to be .... units.
A
Different
B
Indivisible
C
Constant
D
Divisible
Answer:
Question 9. The tuples of the relation can be of ..... order ?
A
Any
B
Same
C
Sorted
D
Constant
Answer:
Question 10.Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record ?
A
Candidate Key
B
Sub Key
C
Super Key
D
Foreign Key