Database Management System! Trivia Questions Quiz

1.

Normal form is a state if a relation that results from applying simple rules regarding functional dependencies (or relationships between attributes) to that relation.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
The explanation for the given answer is that the statement is incorrect. Normal form refers to a state of a relation that satisfies certain conditions regarding functional dependencies. It is not simply the result of applying simple rules regarding functional dependencies to a relation. Therefore, the answer is false.

Rate this question:

2.

Determinants are the attribute on the left-hand side of the arrow in a functional dependency.

A.

TRUE
B.

FALSE

Correct Answer
A. TRUE

Explanation
The statement is true because in a functional dependency, the determinant is the attribute or set of attributes on the left-hand side of the arrow, which determines the value of the attribute or set of attributes on the right-hand side. The determinant is the key or keys that uniquely identify a tuple in a relation.

Rate this question:

3.

First Normal form is a relation in which every non-key attribute is fully functionally dependent on the primary key.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
First Normal Form (1NF) is a relational database design principle that states that each attribute in a relation must have a single value, meaning it should not contain repeating groups or arrays. It does not require every non-key attribute to be fully functionally dependent on the primary key. Therefore, the given statement is false.

Rate this question:

4.

Partial functional dependency is a functional dependency between two (or more) nonkey attributes.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
Partial functional dependency is a functional dependency between a nonkey attribute and a proper subset of the key attributes, rather than between two nonkey attributes. Therefore, the given statement is incorrect.

Rate this question:

5.

There are 3 major steps in normalization.

A.

TRUE
B.

FALSE

Correct Answer
A. TRUE

Explanation
Normalization is a process used in database design to eliminate redundancy and improve data integrity. It involves breaking down a database into multiple tables and establishing relationships between them. The three major steps in normalization are 1) First Normal Form (1NF), which eliminates duplicate data by ensuring each column has a single value, 2) Second Normal Form (2NF), which eliminates partial dependencies by ensuring each non-key column is fully dependent on the primary key, and 3) Third Normal Form (3NF), which eliminates transitive dependencies by ensuring each non-key column is only dependent on the primary key. Therefore, the statement that there are 3 major steps in normalization is true.

Rate this question:

6.

Normalization is the process of decomposing relations with anomalies to produce smaller, well-structured relations.

A.

TRUE
B.

FALSE

Correct Answer
A. TRUE

Explanation
Normalization is a database design technique that helps in organizing data efficiently and reducing redundancy. It involves decomposing relations into smaller, well-structured relations to eliminate anomalies such as insertion, update, and deletion anomalies. By breaking down the data into smaller and more manageable units, normalization ensures data integrity and improves overall database performance. Therefore, the given statement that normalization is the process of decomposing relations with anomalies to produce smaller, well-structured relations is true.

Rate this question:

7.

A candidate key is an attribute or combination of attributes, that uniquely identifies a row in a relation.

A.

TRUE
B.

FALSE

Correct Answer
A. TRUE

Explanation
The given statement is true. A candidate key is an attribute or combination of attributes that can uniquely identify each row in a relation. It means that no two rows in a relation can have the same values for the candidate key attributes. This is an important concept in database design and helps ensure data integrity and uniqueness within a table.

Rate this question:

8.

A functional dependency is a dependency in which one or more non-key attributes are functionally dependent on part (but not all) of the primary key.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
The given statement is incorrect. A functional dependency is a relationship between two sets of attributes in a database. It states that one set of attributes determines the values of another set of attributes. In a functional dependency, all attributes on the right-hand side should be functionally dependent on all attributes on the left-hand side, including the primary key. Therefore, the correct answer is FALSE.

Rate this question:

9.

1NF is a relation that has no transitive dependencies.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
The given statement is incorrect. 1NF (First Normal Form) is a relation that has no repeating groups, meaning that each attribute in a relation should contain only atomic values. Transitive dependencies refer to a situation where the value of one attribute determines the value of another attribute indirectly through a third attribute. Therefore, 1NF does not specifically address transitive dependencies.

Rate this question:

10.

2NF contains no multivalued attributes.

A.

TRUE
B.

FALSE

Correct Answer
B. FALSE

Explanation
The statement "2NF contains no multivalued attributes" is false. In Second Normal Form (2NF), multivalued attributes are allowed. However, 2NF does require that each non-key attribute is functionally dependent on the entire primary key, meaning it cannot be dependent on only part of the primary key.

Rate this question: