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

Which area of database security involves maintaining access to enterprise data?

Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

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?

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?

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 table for an employee database shown in the exhibit. What is the degree of the table?

What is a domain?

A foreign key maps to a:

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

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

Which statement best describes a candidate key?

Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation? Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation?

Which of the following occurs in a relation when records are added or removed?