Home / CSE MCQs / DBMS MCQs :: RDBMS

CSE MCQs :: DBMS MCQs

  1. A relational database consists of a collection of
  2. A.
    Tables
    B.
    Fields
    C.
    Records
    D.
    Keys

  3. A ________ in a table represents a relationship among a set of values.
  4. A.
    Column
    B.
    Key
    C.
    Row
    D.
    Entry

  5. The term _______ is used to refer to a row.
  6. A.
    Attribute
    B.
    Tuple
    C.
    Field
    D.
    Instance

  7. The term attribute refers to a ___________ of a table.
  8. A.
    Record
    B.
    Column
    C.
    Tuple
    D.
    Key

  9. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
  10. A.
    Domain
    B.
    Relation
    C.
    Set
    D.
    Schema

  11. 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.
  12. A.
    Instance, Schema
    B.
    Relation, Schema
    C.
    Relation, Domain
    D.
    Schema, Instance

  13. A domain is atomic if elements of the domain are considered to be ____________ units.
  14. A.
    Different
    B.
    Indivisbile
    C.
    Constant
    D.
    Divisible

  15. The tuples of the relations can be of ________ order.
  16. A.
    Any
    B.
    Same
    C.
    Sorted
    D.
    Constant

  17. Using which language can a user request information from a database ?
  18. A.
    Query
    B.
    Relational
    C.
    Structural
    D.
    Compiler

  19. Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key?
  20. A.
    Name
    B.
    Dept
    C.
    Tot_cred
    D.
    ID