Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

1. A. An update anomaly and an insertion anomaly would occur.
2. B. An insertion anomaly would occur.
3. C. A deletion anomaly would occur.
4. D. A deletion anomaly and an update anomaly would occur.

Correct Answer: B

Consider the following four database design activities:
* 1 - Design user views.
* 2 - Select a DBMS.
* 3 - Apply normalization.
* 4 - Determine entities.
Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

1. A. 1, 2, 3, 4
2. B. 3, 4, 1, 2
3. C. 4, 1, 3, 2
4. D. 4, 2, 3, 1

Correct Answer: D

Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?

1. A. Backups
2. B. User views
3. C. Encryption
4. D. Integrity controls

Correct Answer: C

Which term best defines a database system in which data records are stored with no structured relationships between the records?

1. A. Flat-file database
2. B. Relational database
3. C. Distributed database
4. D. Object-oriented database

Correct Answer: A

Your enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

1. A. Management of data redundancy, increased data integrity, increased data dependence, and increased application complexity
2. B. Consistency of data, adherence to standards, managed concurrency, and increased software complexity
3. C. Increased data access, increased data backup and recovery, data sharing, and consistency of data
4. D. Increased data security, increased data integrity, increased data independence, and decentralization of data

Correct Answer: C