SOLVED

 5.1  Multiple Choice 1) Which of the following is the term for an anomaly in which you cannot enter data because other data is required? A) Insertion anomaly B) Update anomaly C) Deletion anomaly D) None of the above 2) Which of the following is the term for an anomaly in which you must edit the same data in more than one place? A) Insertion anomaly B) Update anomaly C) Deletion anomaly D) None of the above 3) Which of the following is the term for an anomaly in which removing data unintentionally causes the loss of other data? A) Insertion anomaly B) Update anomaly C) Deletion anomaly D) None of the above 4) An insertion anomaly occurs when: A) You cannot enter data because other data is required B) You must edit the same information in several places C) Removing data accidently causes the loss of other data D) None of the above 5) An update anomaly occurs when: A) You cannot enter data because other data is required B) You must edit the same information in several places C) Removing data accidently causes the loss of other data D) None of the above 6) A deletion anomaly occurs when: A) You cannot enter data because other data is required B) You must edit the same information in several places C) Removing data accidently causes the loss of other data D) None of the above 7) Which of the following best defines the term normalization? A) When you cannot enter data because other data is required B) When you must edit the same information in several places C) When removing data accidently causes the loss of other data D) The process of removing anomalies and redundancies from database design 8) Which term best describes the process of removing anomalies and redundancies from a database? A) First Normal Form B) Second Normal Form C) Third Normal Form D) Normalization 9) Which of the following is the normal form that removes all repeating groups and arrays? A) First Normal Form B) Second Normal Form C) Third Normal Form D) Boyce Codd Normal Form 10) Which of the following is the normal form that removes all functional dependencies? A) First Normal Form B) Second Normal Form C) Third Normal Form D) Boyce Codd Normal Form 1