Welcome to Assignment Heroes



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)



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
resource locking


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.



15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.