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.

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

  1. A. A → C. B. B → C. C. (A
  2. B. is a composite determinant. D. C is a determinant.
Report Error

A relation in this form is free of all modification anomalies.

  1. A. First normal form
  2. B. Second normal form
  3. C. Third normal form
  4. D. Domain/key normal form
Report Error

An attribute 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

A key:

  1. A. must always be composed of two or more columns.
  2. B. can only be one column.
  3. C. identifies a row.
  4. D. identifies a column.
Report Error

For some relations, changing the data can have undesirable consequences called:

  1. A. referential integrity constraints.
  2. B. modification anomalies.
  3. C. normal forms.
  4. D. transitive dependencies.
Report Error

Which of the following is not a restriction for a table to be a relation?

  1. A. The cells of the table must contain a single value.
  2. B. All of the entries in any column must be of the same kind.
  3. C. The columns must be ordered.
  4. D. No two rows in a table may be identical.
Report Error

Table is synonymous with the term:

  1. A. record.
  2. B. relation.
  3. C. column.
  4. D. field.
Report Error

A functional dependency is a relationship between or among:

  1. A. tables.
  2. B. rows.
  3. C. relations.
  4. D. attributes.
Report Error

In the relational model, relationships between relations or tables are created by using:

  1. A. composite keys.
  2. B. determinants.
  3. C. candidate keys.
  4. D. foreign keys.
Report Error

A relation is considered a:

  1. A. Column.
  2. B. one-dimensional table.
  3. C. two-dimensional table.
  4. D. three-dimensional table.
Report Error

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

  1. A. transitive dependency.
  2. B. insertion anomaly.
  3. C. referential integrity constraint.
  4. D. normal form.
Report Error

Which of the following is a group of one or more attributes that uniquely identifies a row?

  1. A. Key
  2. B. Determinant
  3. C. Tuple
  4. D. Relation
Report Error