Q1: A key:

A must always be composed of two or more columns.
B can only be one column.
C identifies a row.
D identifies a column.

Q2: An attribute is a(n):

A column of a table.
B two dimensional table.
C row of a table.
D key of a table.

A
A → B.
B
A → C.
C
A → (B,C).
D
(B,C) → A.

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

Q5: A relation in this form is free of all modification anomalies.

A First normal form
B Second normal form
C Third normal form
D Domain/key normal form

Q6: If attributes A and B determine attribute C, then it is also true that:

A
A → C.
B
B → C.
C
(A,B) is a composite determinant.
D C is a determinant.

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

A composite keys.
B determinants.
C candidate keys.
D foreign keys.

Q8: A relation is considered a:

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

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

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

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

A record.
B relation.
C column.
D field.

A Key
B Determinant
C Tuple
D Relation

A
A → B.
B
B → A.
C
C → A.
D
(B,C) → A.

Q15: The primary key is selected from the:

A composite keys.
B determinants.
C candidate keys.
D foreign keys.

Q16: Which of the following is not a restriction for a table to be a relation?

A The cells of the table must contain a single value.
B All of the entries in any column must be of the same kind.
C The columns must be ordered.
D No two rows in a table may be identical.

A record.
B relation.
C column.
D field.

Q18: One solution to the multivalued dependency constraint problem is to:

A split the relation into two relations, each with a single theme.
B change the theme.
C create a new theme.

Q19: A tuple is a(n):

A column of a table.
B two dimensional table.
C row of a table.
D key of a table.

Q20: For some relations, changing the data can have undesirable consequences called:

A referential integrity constraints.
B modification anomalies.
C normal forms.
D transitive dependencies.

For help Students Orientation Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.