The Relational Model and Normalization – General Questions


Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

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

Correct Answer:  A. Key
Advertisement

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.

Correct Answer:  C. referential integrity constraint.
Advertisement

8. A relation is considered a:

A. Column.
B. one-dimensional table.
C. two-dimensional table.
D. hree-dimensional table.

Correct Answer:  C. two-dimensional table.
Advertisement

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.

Correct Answer:  D. foreign keys.
Advertisement

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

A. tables.
B. rows.
C. relations.
D. attributes.

Correct Answer:  D. attributes.
Advertisement

Warning: Undefined variable $in_same_cat in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Warning: Undefined variable $excluded_categories in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Leave A Comment?