The Relational Model and Normalization - General Questions Online Exam Quiz

The Relational Model and Normalization - General Questions GK Quiz. Question and Answers related to The Relational Model and Normalization - General Questions. MCQ (Multiple Choice Questions with answers about The Relational Model and Normalization - General Questions

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:

Options

A : A ? B.

B : A ? C.

C : A ? (B,C).

D : (B,C) ? A.

View Answer

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

Options

A : normal forms.

B : referential integrity constraints.

C : functional dependencies.

D : None of the above is correct.

View Answer

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

Options

A : second normal form.

B : third normal form.

C : fourth normal form.

D : domain/key normal form.

View Answer

Row is synonymous with the term:

Options

A : record.

B : relation.

C : column.

D : field.

View Answer

The primary key is selected from the:

Options

A : composite keys.

B : determinants.

C : candidate keys.

D : foreign keys.

View Answer

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

Options

A : Key

B : Determinant

C : Tuple

D : Relation

View Answer

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

Options

A : transitive dependency.

B : insertion anomaly.

C : referential integrity constraint.

D : normal form.

View Answer

A relation is considered a:

Options

A : Column.

B : one-dimensional table.

C : two-dimensional table.

D : three-dimensional table.

View Answer

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

Options

A : composite keys.

B : determinants.

C : candidate keys.

D : foreign keys.

View Answer

A functional dependency is a relationship between or among:

Options

A : tables.

B : rows.

C : relations.

D : attributes.

View Answer

Advanced SQL - General Questions more Online Exam Quiz

The Client-Server Database - General Questions

The Database Development Process - General Questions

The Database Environment - General Questions

ER Model and Business Rules - General Questions

The Internet Database Environment - General Questions

Data Models into Database Designs - General Questions

XML and ADO.NET - General Questions

Boolean Algebra and Logic Simplification - General Questions

Code Converters and Multiplexers - General Questions

Combinational Logic Analysis - General Questions