Which of the following definitions applies to all types of databases?

1. A. Data that is stored as tables
2. B. Software that manipulates data
3. C. Data that is stored in a structured manner
4. D. Data records that are stored sequentially in a file

Correct Answer: C

Which database security technique prevents invalid data from being entered into the database?

1. A. File locking
2. B. User authorization
3. C. Parity checks
4. D. Integrity controls

Correct Answer: D

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

1. A. m:m
2. B. m:n
3. C. 1:1
4. D. 1:n

Correct Answer: B

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

1. A. Activity_Fee is a determinant of Activity.
2. B. Activity_Fee is partially dependent on the primary key.
3. C. The table contains a transitive dependency.
4. D. Activity_Fee is a determinant of Activity and Student_ID.

Correct Answer: B

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

1. A. SELECT *FROM Dept1_Parts EXCEPT(SELECT Part_IDFROM Dept2_Parts);
2. B. SELECT *FROM Dept1_Parts MINUS(SELECT Part_IDFROM Dept2_Parts);
3. C. SELECT *FROM Dept1_Parts DIFFERENCE (SELECT Part_IDFROM Dept2_Parts);
4. D. SELECT *FROM Dept1_Parts DIFFERENCE (SELECT Part_IDFROM Dept2_Parts);

Correct Answer: D