Multiple type questions from Relational model and normalization

February 27, 2020
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: Option A
Explanation:
No answer description available for this question.
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: Option A
Explanation:
No answer description available for this question.
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: Option C
Explanation:
No answer description available for this question.
4.  Row is synonymous with the term:
A. record.
B. relation.
C. column.
D. field.

Answer: Option A
Explanation:
No answer description available for this question.
5.  The primary key is selected from the:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.

Answer: Option C
Explanation:
No answer description available for this question.
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: Option A
Explanation:
No answer description available for this question.
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: Option C
Explanation:
No answer description available for this question.
8.  A relation is considered a:
A. Column.
B. one-dimensional table.
C. two-dimensional table.
D. three-dimensional table.

Answer: Option C
Explanation:
No answer description available for this question.
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: Option D
Explanation:
No answer description available for this question.
10.  A functional dependency is a relationship between or among:
A. tables.
B. rows.
C. relations.
D. attributes.

Answer: Option D
Explanation:
No answer description available for this question.

Please write your comment  about this multiple type questions. your comments are very valuable for me! so please write about this through comment sections!
Thankyou!

2 Comments