1. Consider the Project relation shown in the exhibit as well as the following SQL statement: Which of the following tables shows the Project relation after execution of this SQL statement?

2. Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

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

4. Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

5. Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

6. Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

7. What is the highest normal form of the relation(s) shown in the exhibit?

8. Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

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

10. Which term describes one or more database operations that are executed as a single unit?

11. Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

12. Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

13. Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?

14. 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?

15. Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

16. Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

17. A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

18. Consider the following DBDL description of an entity: Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied?

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

20. Consider the relational database shown in the exhibit. What is the foreign key in this database?

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

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

23. Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

24. Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

25. 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?