Incorrect Question 5 A model is How the schema organizes the constraints How the database engine represents the data How keys are enforced How the normalization rules are enforced 0 Incorrect Question 7 Given this expression, what can we say about the problem domain? tBoat (BoatSerialNo, BoatType, Manufacturer, Price, Customer, DateOfSale, SalesRep) SalesRep should not be in the expression at all BoatSerialNumber->Manufacturer Price->BoatSerialNumber 0/ BoatSerialNumber->Price None of these Incorrect Question 9 SQL is not case-sensitive Compiled Object-oriented Based on C# Incorrect Question 10 In SQL There is FOR and WHILE but no DO-WHILE There is no looping at all There is no WHILE loop There is no FOR loop ncorrect Question 12 A trigger can be assigned to a(n) login schema database None of these Question 13 Given the expression below, what can be said about f? R(a,b,c,d,e,f,g) a, b->c a,b->g ture.com/courses/1563966/quizzes/4820761 a->d d->e a,b determines f f is a natural key f determines a,b 0/2 Final Exam Fall 2022: (22FS-Full) DATABASE MANAGEMENT II (001) f probably should not be in R because it is not determined by anything in R Question 24 Given this expression: R(A,B,C,D) What statement best describes it? Normalization Schema Constraint Logical Design ure.com/courses/1563966/quizzes/4820761 None of these Final Exam Fall 202 Question 26 What is required to define a determinant? Domain knowledge Extraterrestrial Information Database constraints Relational information None of these Question 28 Normalization is used to None of these reduce update anomalies optimize data retrieval normalize storage requirements create a distributed environment Question 30 Which level of normalization requires the definition of a candidate key? None of these BCNF 1st 3rd 0/1 F 2nd correct Question 34 What is the cursor available in a trigger that contains the rows being added to the target table? INSERTING INSERTED INSERT INS 0/ None of these Incorrect Question 41 This person (or persons) understands the real-world aspects of the system being modeled by the database. Domain expert Database Expert Database Manager Project Supervisor 0 DBA Incorrect Question 43 This type of database is optimized for retrieval and is not normalized in the fashion we have studied Universal Database Data Planet None of these World of Data 0/1 F Data Warehouse Incorrect Question 48 What best practice is violated by this expression: 2/5/22, 9:02 PM SELECT * FROM tBook https://uc.instructure.com/courses/1563966/quizzes/4820761 Final Exam Fall 2022: (22FS-Full) DATABASE MANAGI Always provide an ORDER BY clause in a query Don't read data directly from a table Don't use the wildcard when specifying columns in a query Always wrap code in a TRY/CATCH