CIS 321 Week 7 Quiz – With 100% Correct Answers – Download To Score An A+

Part 1 of 1 - 100.0/ 100.0 Points Question 1 of 10 10.0/ 10.0 Points When a table does not contain a repeating group, it is called: • A. 2NF • B. 1NF • C. Unnormalized relation • D. 3NF Answer Key:B Question 2 of 10 10.0/ 10.0 Points Any column or collection of columns that determines another column is called a • A. column spec. B. determinant. • C. column form. • D. none of the above. Answer Key:B Question 3 of 10 10.0/ 10.0 Points A user view is defined as: • A. the set of requirements necessary to support ops of a particular database user. • B. the method use to view the entire database tables. • C. the view of a particular user report. D. none of the above. Answer Key:A Question 4 of 10 10.0/ 10.0 Points Information gathered during requirements collection and analysis for each major user view includes: • A. a description of the data used or generated. • B. the details of how data is to be used or generated. • C. any additional requirements for the new database system. • D. all of the above. Answer Key:D Question 5 of 10 10.0/ 10.0 Points Candidate keys that are not selected to be the primary key: • A. Natural Key • B. Alternate Key • C. Artificial Key • D. Surrogate Key Answer Key:B Question 6 of 10 10.0/ 10.0 Points The bottom-up database design approach is more appropriate than a top-down design for complex databases. • A. true • B. false Answer Key:B Question 7 of 10 10.0/ 10.0 Points The description of the data in a database is known as: • A. megadata. • B. super catalog. • C. mega listing. • D. data dictionary. Answer Key:D Question 8 of 10 10.0/ 10.0 Points What is the process called to deny access to other users while the DBMS processes one user's updates? A. Lockout • B. Excluding • C. Locking • D. None of the above. Answer Key:C Question 9 of 10 10.0/ 10.0 Points Cardinality describes the maximum number of possible relationship occurrences for a (an): • A. Field • B. Row C. Entity • D. Database Answer Key:C Question 10 of 10 10.0/ 10.0 Points Identifying entity types, identifying relationship types, and determining attribute domains are part of which design phase? • A. Logical design • B. Conceptual design • C. Physical design • D. none of the above. Answer Key:B