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.
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.
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.
Row is synonymous with the term:
Options
A : record.
B : relation.
C : column.
D : field.
The primary key is selected from the:
Options
A : composite keys.
B : determinants.
C : candidate keys.
D : foreign keys.
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
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.
A relation is considered a:
Options
A : Column.
B : one-dimensional table.
C : two-dimensional table.
D : three-dimensional table.
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.
A functional dependency is a relationship between or among:
Options
A : tables.
B : rows.
C : relations.
D : attributes.
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