1. (TCO A) A program whose job is to create, process, and administer databases is called a _____. (Points : 5) database modeling system database management system data business model system relational model manager data business management service Question 2. 2. (TCO B) Attributes may be _____. (Points : 5) A. composite identifiers B. elements C. multivalued D. strong or weak A and C Question 3. 3. (TCO C) A relation is in Boyce-Codd normal form if _____. (Points : 5) there is more than one primary key every attribute is a candidate key there is more than one candidate key every determinant is a primary key every determinant is a candidate key Question 4. 4. (TCO C) A table that meets the definition of a relation is in _____ (Points : 5) third normal form fourth normal form Boyce-Codd normal form second normal form first normal form Question 5. 5. (TCO D) In a SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified criteria? (Points : 5) AND EXISTS HAVING IN WHERE Question 6. 6. (TCO E) We have obtained access to the company’s operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code, 567. This is an example of _____. (Points : 5) dirty data inconsistent data nonintegrated data a “wrong format” problem a “too much data” problem Question 7. 7. (TCO E) One remedy for the inconsistencies caused by concurrent processing is _____. (Points : 5) lost updates checkpointing rollback resource locking concurrency Question 8. 8. (TCO F) When the correct SQL command is used to delete a table’s structure, what happens to the data in the table? (Points : 5) A. If the deleted table was a parent table, the data are added to the appropriate rows of the child table. B. If the deleted table was a child table, the data are added to the appropriate rows of the parent table. C. The data in the table are also deleted. D. Nothing, because there were no data in the table, because only an empty table can be deleted. A and B Question 9. 9. (TCO G) Which type of lock still allows other transactions to have read-only access to the locked resource? (Points : 5) Exclusive lock Shared lock Two-phased lock Explicit lock Implicit lock Question 10. 10. (TCO G) Locks that are placed in the assumption that a conflict will occur are called (Points : 5) dynamic locks. explicit locks. implicit locks. optimistic locks. pessimistic locks.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |