1. What is First normal form ? Junior A. a constraint stating that one set of columns uniquely determines the value of another set B. a system-generated identifier with no business meaning used as the primary key in place of real attributes C. the rule requiring every column to hold a single atomic value with no repeating groups or arrays D. a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate
2. Which term means: "the rule requiring every column to hold a single atomic value with no repeating groups or arrays"? Junior A. First normal form B. Functional dependency C. Denormalization D. Second normal form
3. Which statement is correct? Junior A. First normal form — the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. First normal form — the rule requiring every column to hold a single atomic value with no repeating groups or arrays C. First normal form — a stricter refinement where every determinant of any dependency must itself be a candidate key D. First normal form — the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort
4. What is Second normal form ? Mid A. a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate B. a stricter refinement where every determinant of any dependency must itself be a candidate key C. a system-generated identifier with no business meaning used as the primary key in place of real attributes D. the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it
5. Which term means: "the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it"? Mid A. Transitive dependency B. Functional dependency C. Boyce-Codd normal form D. Second normal form
6. Which statement is correct? Mid A. Second normal form — the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. Second normal form — a system-generated identifier with no business meaning used as the primary key in place of real attributes C. Second normal form — a stricter refinement where every determinant of any dependency must itself be a candidate key D. Second normal form — the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort
7. What is Third normal form ? Mid A. the rule requiring every column to hold a single atomic value with no repeating groups or arrays B. the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns C. a stricter refinement where every determinant of any dependency must itself be a candidate key D. the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort
8. Which term means: "the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns"? Mid A. Second normal form B. Third normal form C. Functional dependency D. Boyce-Codd normal form
9. Which statement is correct? Mid A. Third normal form — a stricter refinement where every determinant of any dependency must itself be a candidate key B. Third normal form — the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort C. Third normal form — the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns D. Third normal form — a system-generated identifier with no business meaning used as the primary key in place of real attributes
10. What is Boyce-Codd normal form ? Senior A. the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. a stricter refinement where every determinant of any dependency must itself be a candidate key C. the rule requiring every column to hold a single atomic value with no repeating groups or arrays D. a system-generated identifier with no business meaning used as the primary key in place of real attributes
11. Which term means: "a stricter refinement where every determinant of any dependency must itself be a candidate key"? Senior A. Functional dependency B. Boyce-Codd normal form C. Transitive dependency D. Third normal form
12. Which statement is correct? Senior A. Boyce-Codd normal form — a stricter refinement where every determinant of any dependency must itself be a candidate key B. Boyce-Codd normal form — the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns C. Boyce-Codd normal form — a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate D. Boyce-Codd normal form — a system-generated identifier with no business meaning used as the primary key in place of real attributes
13. What is Functional dependency ? Mid A. the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort C. a constraint stating that one set of columns uniquely determines the value of another set D. the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns
14. Which term means: "a constraint stating that one set of columns uniquely determines the value of another set"? Mid A. First normal form B. Functional dependency C. Surrogate key D. Boyce-Codd normal form
15. Which statement is correct? Mid A. Functional dependency — the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns B. Functional dependency — a stricter refinement where every determinant of any dependency must itself be a candidate key C. Functional dependency — a constraint stating that one set of columns uniquely determines the value of another set D. Functional dependency — a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate
16. What is Denormalization ? Mid A. a system-generated identifier with no business meaning used as the primary key in place of real attributes B. the rule requiring every column to hold a single atomic value with no repeating groups or arrays C. the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it D. the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort
17. Which term means: "the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort"? Mid A. First normal form B. Denormalization C. Boyce-Codd normal form D. Transitive dependency
18. Which statement is correct? Mid A. Denormalization — a constraint stating that one set of columns uniquely determines the value of another set B. Denormalization — a system-generated identifier with no business meaning used as the primary key in place of real attributes C. Denormalization — the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort D. Denormalization — the rule requiring every column to hold a single atomic value with no repeating groups or arrays
19. What is Surrogate key ? Mid A. the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. the rule requiring every column to hold a single atomic value with no repeating groups or arrays C. a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate D. a system-generated identifier with no business meaning used as the primary key in place of real attributes
20. Which term means: "a system-generated identifier with no business meaning used as the primary key in place of real attributes"? Mid A. Functional dependency B. Surrogate key C. Boyce-Codd normal form D. First normal form
21. Which statement is correct? Mid A. Surrogate key — the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it B. Surrogate key — a constraint stating that one set of columns uniquely determines the value of another set C. Surrogate key — a system-generated identifier with no business meaning used as the primary key in place of real attributes D. Surrogate key — a stricter refinement where every determinant of any dependency must itself be a candidate key
22. What is Transitive dependency ? Senior A. a system-generated identifier with no business meaning used as the primary key in place of real attributes B. the rule requiring every column to hold a single atomic value with no repeating groups or arrays C. a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate D. a constraint stating that one set of columns uniquely determines the value of another set
23. Which term means: "a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate"? Senior A. Transitive dependency B. Functional dependency C. Denormalization D. Third normal form
24. Which statement is correct? Senior A. Transitive dependency — the deliberate reintroduction of redundancy to speed reads at the cost of extra write and consistency effort B. Transitive dependency — the rule that removes transitive dependencies so non-key columns depend only on the key and not on other non-key columns C. Transitive dependency — a relationship where a non-key column determines another non-key column, which third normal form is designed to eliminate D. Transitive dependency — the rule that, beyond atomicity, every non-key column must depend on the whole composite key rather than only part of it