officerpath@gmail.com Hyderabad, Pakistan
Login Register
Latest Jobs CSS 2025 PMS CCE Sindh FPSC PPSC MCQs Past Papers Current Affairs Scholarships Admissions Downloads Roll No. Slips Results
Commerce

The Relational Model And Normalization MCQs

Practice The Relational Model And Normalization MCQs for competitive exams.

The Relational Model And Normalization MCQs

Practice questions from this topic.

The functional dependency R → S means that the value of S can be determined when we are given a value of R.

  1. A. True
  2. B. False
Report Error

A relation is in 5NF when multivalued dependencies are isolated in their own relation.

  1. A. True
  2. B. False
Report Error

The only reason for the existence of relations is to store instances of functional dependencies.

  1. A. True
  2. B. False
Report Error

A candidate key is a determinant that determines all the other columns is a relation.

  1. A. True
  2. B. False
Report Error

Given the functional dependency R → (S,T) , then it is also true that R → S .

  1. A. True
  2. B. False
Report Error

Any table that meets the definition of a relation is said to be in first normal form.

  1. A. True
  2. B. False
Report Error

A relation is a two-dimensional table.

  1. A. True
  2. B. False
Report Error

In a relation, the rows are sometimes called "records".

  1. A. True
  2. B. False
Report Error

In a relation, the order of the rows matters.

  1. A. True
  2. B. False
Report Error

One solution to the multivalued dependency constraint problem is to:

  1. A. split the relation into two relations, each with a single theme.
  2. B. change the theme.
  3. C. create a new theme.
  4. D. add a composite key.
Report Error

If attribute A determines both attributes B and C, then it is also true that:

  1. A. A →
  2. B. B. B → A. C. C → A. D. (B
  3. C. → A.
Report Error

A tuple is a(n):

  1. A. column of a table.
  2. B. two dimensional table.
  3. C. row of a table.
  4. D. key of a table.
Report Error