The Relational Model and Normalization - Database MCQ Questions and answers- Technical Aptitude

1.
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A. A → B.

B. A → C.

C. A → (B,C).

D. (B,C) → A.

Answer & Solution Discuss in Board Save for Later

2.
The different classes of relations created by the technique for preventing modification anomalies are called:

A. normal forms.

B. referential integrity constraints.

C. functional dependencies.

D. None of the above is correct.

Answer & Solution Discuss in Board Save for Later

3.
A relation is in this form if it is in BCNF and has no multivalued dependencies:

A. second normal form.

B. third normal form.

C. fourth normal form.

D. domain/key normal form.

Answer & Solution Discuss in Board Save for Later

4.
Row is synonymous with the term:

A. record.

B. relation.

C. column.

D. field.

Answer & Solution Discuss in Board Save for Later

5.
The primary key is selected from the:

A. composite keys.

B. determinants.

C. candidate keys.

D. foreign keys.

Answer & Solution Discuss in Board Save for Later

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

A. Key

B. Determinant

C. Tuple

D. Relation

Answer & Solution Discuss in Board Save for Later

7.
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):

A. transitive dependency.

B. insertion anomaly.

C. referential integrity constraint.

D. normal form.

Answer & Solution Discuss in Board Save for Later

8.
A relation is considered a:

A. Column.

B. one-dimensional table.

C. two-dimensional table.

D. three-dimensional table.

Answer & Solution Discuss in Board Save for Later

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

A. composite keys.

B. determinants.

C. candidate keys.

D. foreign keys.

Answer & Solution Discuss in Board Save for Later

10.
A functional dependency is a relationship between or among:

A. tables.

B. rows.

C. relations.

D. attributes.

Answer & Solution Discuss in Board Save for Later

The Relational Model and Normalization - Database MCQ Questions and answers- Technical Aptitude

1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

Answer & Solution

2. The different classes of relations created by the technique for preventing modification anomalies are called:

Answer & Solution

3. A relation is in this form if it is in BCNF and has no multivalued dependencies:

Answer & Solution

4. Row is synonymous with the term:

Answer & Solution

5. The primary key is selected from the:

Answer & Solution

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

Answer & Solution

7. 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):

Answer & Solution

8. A relation is considered a:

Answer & Solution

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

Answer & Solution

10. A functional dependency is a relationship between or among:

Answer & Solution

1.
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

2.
The different classes of relations created by the technique for preventing modification anomalies are called:

3.
A relation is in this form if it is in BCNF and has no multivalued dependencies:

4.
Row is synonymous with the term:

5.
The primary key is selected from the:

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

7.
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):

8.
A relation is considered a:

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

10.
A functional dependency is a relationship between or among: