1D0-541 Free Practice Test

Which term describes the rejoining of relations that have been decomposed?

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

Correct Answer: B

What is a domain?

1. A. A normalized set of data applicable to a particular relation
2. B. A combination of attributes for a relation
3. C. A definition of permissible values for one or more attributes
4. D. A set of permissible values for one or more relations

Correct Answer: C

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

1. A. View
2. B. Data dictionary
3. C. Database control language
4. D. Database management system

Correct Answer: A

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

1. A. SELECT *FROM CustomersWHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
2. B. SELECT *FROM CustomersWHERE Satisfaction_Rate IN (80 AND 90);
3. C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
4. D. SELECT *FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Correct Answer: C

Which security technique limits access by unauthorized users to parts of an enterprise database?

1. A. Views
2. B. Concurrency
3. C. Locking
4. D. Integrity controls

Correct Answer: A