CIW CIW Certifications 1D0-541 Questions & Answers

• Question 61:

  Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called

  Emp_Dept that allows users to find employees and their department ID numbers.

  Which SQL statement will accomplish this?

  

  A. CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;

  B. UPDATE VIEW Emp_Dept AS SELECT * FROM Employee;

  C. UPDATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;

  D. CREATE VIEW Emp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

  Correct Answer: A

• Question 62:

  The exhibit shows a relation for a companys projects. Which candidate key(s) would best serve as the primary key for this relation?

  

  A. S_Date and E_Date

  B. Proj_ID

  C. Item_Num and E_Date

  D. Proj_ID and Item_Num

  Correct Answer: D

• Question 63:

  What is the highest normal form of the relation(s) shown in the exhibit?

  

  A. Third normal form

  B. Second normal form

  C. Boyce-Codd normal form

  D. First normal form

  Correct Answer: D

• Question 64:

  What is the highest normal form of the relation(s) shown in the exhibit?

  

  A. Boyce-Codd normal form

  B. First normal form

  C. Second normal form

  D. Third normal form

  Correct Answer: C

• Question 65:

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

  A. Thin client

  B. Fat client

  C. Database server

  D. Application server

  Correct Answer: D

• Question 66:

  Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

  

  A. SELECT Course_Code FROM Registration;

  B. SELECT * FROM Registration WHERE Registration_ID = 1003

  AND Registration_ID = 1005;

  C. SELECT * FROM Registration WHERE Course_Code = 'A4343';

  D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM Registration WHERE Course_Code = 'A4343';

  Correct Answer: C

• Question 67:

  Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

  A. Durability

  B. Consistency

  C. Isolation

  D. Atomicity

  Correct Answer: D

• Question 68:

  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 69:

  Which of the following is a characteristic of the three-tier database architecture?

  A. A Web browser is used as the application server.

  B. The application logic is centralized on a dedicated server.

  C. A thick client is used to perform business application logic functions locally.

  D. Database application logic and database functionality are integrated and reside on a common server.

  Correct Answer: B

• Question 70:

  Which type of dependency occurs when one attribute of a composite primary key is removed and the dependency still exists?

  A. 11

  B. Transitive

  C. Functional

  D. Partial functional

  Correct Answer: D