1D0-541 CIW v5 Database Design Specialist Questions and Answers

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

In a relational database, which term describes a single table consisting of rows and columns?

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

Which component in the three-tier database architecture handles the data-processing and business logic?

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

Consider the following relational algebraic expression as well as the Dept1_Parta and Dept2_Parts relations shown in the exhibit: Which of the following relations would result form the given relational algebraic expression?

The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project

WHERE Cust_Name = Acme;

Which of the following tables shows the Project relation after execution of this SQL statement?

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the

Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

Which statement is used to define a named group of related tables, views, domains and other database objects?

FROM Registration WHERE

Consider the following relational algebraic expression: Which of the following SQL Course_Code = 'A4343';

statements is equivalent to this relational algebraic expression?

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

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

The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

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?