Theory Of Database Quiz 7 Bscs2a
(26).webp "Theory Of Database Quiz 7 Bscs2a - Quiz")
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.
Key attribute
- B.
Mutual independence
- C.
Non-key attribute
- D.
Determinant
- 3.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
- 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
Recent Quizzes
Featured Quizzes
Popular Topics
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top