Question 5 A model is uc.instructure.com/courses/1563966/quizzes/4820761/take 2, 7:02 PM How the schema organizes the constraints Quiz:...

Transcribed Image Text:

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