CIW CIW Certifications 1D0-541 Questions & Answers

• Question 71:

  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?

  A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;

  B. REVOKE UPDATE FOR Employees FROM Group_2;

  C. REVOKE INSERT, UPDATE, DELETE ON Employees TO Group_2;

  D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;

  Correct Answer: A

• Question 72:

  Which mechanism provides database users with controlled access to the database through the use of virtual tables?

  A. View

  B. Data dictionary

  C. Database control language

  D. Database management system

  Correct Answer: A

• Question 73:

  Which relational algebraic operation is used to select specific columns (attributes) from a relation?

  A. Union

  B. Difference

  C. Projection

  D. Intersection

  Correct Answer: C

• Question 74:

  Which of the following definitions best describes an entity?

  A. A single relation

  B. Data about data

  C. Data stored in a table column

  D. An item about which information is stored

  Correct Answer: D

• Question 75:

  Which subset of Structured Query Language (SQL) is used to create and name database entities?

  A. Data Control Language

  B. Database Entity Language

  C. Data Definition Language

  D. Data Manipulation Language

  Correct Answer: C

• Question 76:

  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?

  

  A. An update anomaly would occur.

  B. An insertion anomaly would occur.

  C. A deletion anomaly would occur.

  D. Both an insertion anomaly and a deletion anomaly would occur.

  Correct Answer: C

• Question 77:

  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.

  Correct Answer: B

• Question 78:

  Which term describes the rejoining of relations that have been decomposed?

  A. Normalization

  B. Denormalization

  C. Referential integrity

  D. Domain constraints

  Correct Answer: B

• Question 79:

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

  

  A. INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);

  B. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);

  C. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

  D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

  Correct Answer: D

• Question 80:

  Which type of entity must reference another entity for its data to be meaningful?

  A. Weak

  B. Strong

  C. Foreign

  D. Primary

  Correct Answer: A