CIW CIW Certification 1D0-541 Questions & Answers

• Question 1:

  Which term describes the management of simultaneous transactions to prevent conflicts?

  A. Parallelism

  B. Serialization

  C. Database control

  D. Concurrency control

  Correct Answer: D

• Question 2:

  Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

  

  Which of the following relational algebraic expressions would result in the given table?

  

  

  A. B. C. D.

  Correct Answer: A

• Question 3:

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

  A. Update

  B. Transaction

  C. Procedure

  D. Singleton

  Correct Answer: B

• Question 4:

  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.

  Correct Answer: A

• Question 5:

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

  A. Entity

  B. Domain

  C. Primary key

  D. Attribute group

  Correct Answer: C

• Question 6:

  A foreign key maps to a:

  A. prime key.

  B. indirect key.

  C. parent key.

  D. composite key.

  Correct Answer: C

• Question 7:

  What is a candidate key?

  A. The primary key for an entity

  B. The key that identifies every instance of an entity

  C. Multiple primary keys that are joined together to form a composite key

  D. A key that may be used to form the primary key

  Correct Answer: D

• Question 8:

  Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

  

  A. SELECT * FROM Employee;

  B. SELECT ID, Last_Name FROM Employee; WHERE ID = 0004;

  C. SELECT * FROM Employee WHERE Dept_ID = 022;

  D. SELECT * FROM Employee WHERE Dept_ID = 022;

  Correct Answer: C

• Question 9:

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

  

  A. Union

  B. Selection

  C. Projection

  D. Difference

  Correct Answer: B

• Question 10:

  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.

  Correct Answer: C