DataBase Management System

Relational Model in DBMS

⛪ Computer Science and Engineering > DataBase Management System

A relation is used to represent information about any entity and its relationship with other entities in the form of attributes (or columns) and tuples (or rows). It comprises a relation schema and a relation instance. A relational database is a collection of relations (or two-dimensional tables) having distinct names. It is a persistent storage mechanism that conforms to the relational model.

Test your knowledge of the Relational Model in DBMS with our interactive and challenging MCQ (Multiple Choice Questions) quiz. Covering topics such as tables, keys, normalization, and SQL, our quiz is designed to help you improve your understanding of the Relational Model and prepare for interviews or exams.

➲ Relational Model in DBMS - Quiz

Q 1: The relational model is based on the branches of

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

Q 2: The relational model includes:

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

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

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

Q 4: Which of the following does not belong to relation schema?

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

Q 5: Which of the following factors indicates that a table is not well-structured?

  • A The primary key consists of more than one attribute.
  • B Referential integrity is violated when attempting to enter data.
  • C It contains multiple foreign keys.
  • D All of these.

Q 6: Candidate key is also known as

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

Q 7: Which of the following keys describes a field, or a combination of fields, that has a unique value?

  • A Secondary key
  • B Foreign key
  • C Primary key
  • D Alternate key

Q 8: 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

Q 9: 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.

Q 10: Integrity constraints can be divided into

  • A One
  • B Two
  • C Three
  • D Four

Q 11: Which of the following integrity is applied on the tuple?

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

Q 12: 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

Q 13: The constraint that can be applied only at column level is

  • A Primary key constraint
  • B Foreign key constraint
  • C Unique constraint
  • D Not Null constraint

Q 14: 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.

Q 15: While mapping relationship types to a relation, which of the following relationship types allows us to choose the primary key of either participating entity type as the primary key of the relation?

  • A Many-to-many
  • B One-to-many
  • C One-to-one
  • D All of these