Relational Model in DBMS - Quiz

Candidate key is also known as

  • A Superkey
  • B Irreducible superkey
  • C Foreign key
  • D Primary key

A foreign key must

  • A Be numeric.
  • B Match the field value of a primary key in a related table.
  • C Be defined in all tables in the database.
  • D Be unique.

Which of the following is not true with primary key constraint?

  • A Primary key attribute cannot have null value.
  • B Primary key constraint enforces entity integrity.
  • C Unique key constraint is preferable over primary key constraint.
  • D Multiple primary key constraints can be defined on a relation.

What does referential integrity prevent?

  • A Recursive joins
  • B Loss of data from employee sabotage
  • C Loss of data from any one corrupted table
  • D Data redundancy

When more than one attribute forms the primary key, the key is known as

  • A Foreign key
  • B Alternate key
  • C Candidate key
  • D Composite key

Which of the following data structures is used in relational model?

  • A Table
  • B Tree
  • C Node
  • D None of these

Which of the following does not belong to relation schema?

  • A Tuples
  • B Set of attributes
  • C Relation name
  • D Both (b) and (c)

The relational model includes:

  • A Manipulative components
  • B Integrity constraints
  • C Structural components
  • D All of these

Which of the following integrity is applied on the tuple?

  • A Semantic integrity
  • B Referential integrity
  • C Entity integrity
  • D Domain integrity

The relational model is based on the branches of

  • A Engineering
  • B Mathematics
  • C Science
  • D None of these