Which relational algebraic operation is used to select specific columns (attributes) from a relation?
Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Which of the following is a characteristic of the three-tier database architecture?

1. A. A Web browser is used as the application server.
2. B. The application logic is centralized on a dedicated server.
3. C. A thick client is used to perform business application logic functions locally.
4. D. Database application logic and database functionality are integrated and reside on a common server.

Correct Answer: B

Which concurrency control method should be used only when conflicts between transactions rarely occur?

1. A. Locking
2. B. Time stamps
3. C. Optimistic
4. D. Serialization

Correct Answer: C

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

The exhibit shows a table called Housing Relation. This table relates a unique student identification number with a dormitory building and a room fee for that building. The key for the Housing Relation is Student_ID. If each building charges only one fee and a student can live in only one building, then this table is in which normal form?

1. A. 1NF
2. B. 1NF and 2NF
3. C. 1NF, 2NF, and 3NF
4. D. 1NF, 2NF, 3NF, and BCNF

Correct Answer: B