Theory Of Database Quiz 7 Act2b
Choose the letter of the correct answer
- 1.It is defined as the process of applying a series of techniques and rules to a database in order to reduce data redundancy
- A.
Normalization
- B.
Normal form
- C.
Projection
- 2.it is a description of the rules that a database at a certain level of normalization must follow
- A.
Normalization
- B.
Normal form
- C.
Projection
- 3.it is defined as any attribute that does not participate in the primary key of the relation concerned
- A.
Key attribute
- B.
Mutual independence
- C.
Non-key attribute
- D.
Determinant
- 4.This condition exists among attributes within a relation if none of them are functionally dependent on any combination of the others
- A.
Key attribute
- B.
Non-key attribute
- C.
Determinant
- D.
Mutual independence
- 5.If a table is in second normal form.
- A.
It is also in first normal form
- B.
It is also in third normal form
- C.
It does not contain any transitive dependencies
- D.
It contains attributes that are not fully functionally dependent on the key
- 6.It is a normal form that states that all underlying simple domains contain atomic values only
- A.
3NF or Third Normal Form
- B.
2NF or second normal form
- C.
1NF or First normal form
- D.
Normalization
- 7.If a table is in third normal form
- A.
It is also in Boyce-Codd normal form
- B.
It contains non-atomic attributes
- C.
It does not contain any transitive dependencies
- D.
It contains attributes that are not fully functionally dependent on the key
- 8.It is a normal form that states that every nonkey attribute is fully dependent on the primary key.
- A.
3NF or Third Normal Form
- B.
2NF or second normal form
- C.
1NF or First normal form
- D.
Normalization
- 9.It is a normal form if and only if every determinant is a candidate key
- A.
3NF or Third Normal Form
- B.
2NF or second normal form
- C.
1NF or First normal form
- D.
BCNF or Boyce-Codd normal form
- 10.It is a normal form if and only if it is in 2NF and every non-key attribute is nontransitively dependent on the primary key.
- A.
3NF or Third Normal Form
- B.
2NF or second normal form
- C.
1NF or First normal form
- D.
Normalization
Questions: 9 | Attempts: 8562 | Last updated: Mar 21, 2022
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Questions: 31 | Attempts: 7453 | Last updated: Mar 22, 2022
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 15 | Attempts: 7024 | Last updated: May 1, 2022
-
Sample QuestionThe Yellow Pages is an example of a paper-based database. True or false?
Back to top