DBMS Multiple Choice Question

Question 1. A relational database consists of a collection of ?

  • A

    Tables

  • B

    Fields

  • C

    Records

  • D

    Keys

Answer:
A - Tables

Question 2. A ..... in a table represents a relationship amount a set of values.

  • A

    Column

  • B

    Keys

  • C

    Row

  • D

    Entry

Answer:
A - Column

Question 3. The term .... is used to refer to a row

  • A

    Attribute

  • B

    Tuple

  • C

    Field

  • D

    Instance

Answer:
B - Tuple

Question 4. The term attribute refers to a .... of a table.

  • A

    Record

  • B

    Column

  • C

    Tuple

  • D

    Key

Answer:
B - Column

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:
A - Domain

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:
Schema, Instance

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:
B - course_id , sec_id , semester is a set of attribute and course is a relation.

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:
B - Indivisible

Question 9. The tuples of the relation can be of ..... order ?

  • A

    Any

  • B

    Same

  • C

    Sorted

  • D

    Constant

Answer:
A - Any

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

Answer:
C - Super Key