To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

1. A. GRANT
2. B. REVOKE
3. C. SELECT
4. D. CREATE VIEW

Correct Answer: C

Which of the following best describes a composite key?

1. A. A composite key is a primary key and foreign key that consists of the first two attributes of a relation.
2. B. A composite key is a primary or foreign key defined by its parent key attributes.
3. C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.
4. D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Correct Answer: D

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

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

1. A. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
2. B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;
3. C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
4. D. SELECT *FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;

Correct Answer: D

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


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A