CIW 1D0-541 dumps - 100% Pass Guarantee!

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

A. 11

B. 1n

C. n:m

D. m:n

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

A. SELECT Sales_Rep_No(108) FROM Orders;

B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;

C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

D. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

A. Activity_Fee is a determinant of Activity.

B. Activity_Fee is partially dependent on the primary key.

C. The table contains a transitive dependency.

D. Activity_Fee is a determinant of Activity and Student_ID.

Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?

A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.

B. If a parent key is deleted, no test is made for referential integrity.

C. If any child key references a parent key, the record containing the parent key cannot be deleted.

D. If a parent key is deleted, all child keys are automatically set to a specified value.

Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational

algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

A. B. C. D.