Your enterprise is involved in planning a database project. The exhibit shows the result of
one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

1. A. Information Engineering (IE) data model
2. B. Corporate data model
3. C. Database requirements model
4. D. Entity Relation Data (ERD) model

Correct Answer: B

Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

1. A. Data Control Language
2. B. Data Definition Language
3. C. Data Formatting Language
4. D. Data Manipulation Language

Correct Answer: D

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

1. A. SELECT Course_Code FROM Registration;
2. B. SELECT *FROM RegistrationWHERE Registration_ID = 1003 AND Registration_ID = 1005;
3. C. SELECT *FROM RegistrationWHERE Course_Code = 'A4343';
4. D. SELECT Registration_ID, Student_ID, First_Name, Last_NameFROM RegistrationWHERE Course_Code = 'A4343';

Correct Answer: C

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

1. A. Degree of a relation
2. B. Cardinality of a relation
3. C. Primary key of a relation
4. D. Determinant of a relation

Correct Answer: B

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