Which type of relational integrity is violated if a primary key in a database has a null value?

1. A. Entity integrity
2. B. Domain integrity
3. C. Domain constraints
4. D. Referential integrity

Correct Answer: A

For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

A. 0002, James, Smith

1. A. 0002, James, Smith, 10-25-76
2. B. First_Name, James, Last_Name, Smith
3. C. Emp_ID, 0002, First_Name, James, Last_Name, Smith

Correct Answer: B

Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

1. A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.
2. B. A user who has no knowledge of the softwares underlying code tests the software.
3. C. Someone other than the database designer tests the softwar
4. D. This person has no access to the underlying code and attempts to use thesoftware only in ways not considered by the software designers.
5. E. A person tests the software and submits suggestions to the software's underlying code.This person is someone other than the databasedesigner, but has access to the softwares underlying code.

Correct Answer: D

Which statement accurately describes a characteristic of attributes?
Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Which area of database security involves maintaining access to enterprise data?

1. A. Integrity
2. B. Privacy
3. C. Availability
4. D. Confidentiality

Correct Answer: C