Free CIW 1D0-541 Exam Dumps Questions & Answers

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 VIEWEmp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;
• B.CREATE VIEWEmp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• C.UPDATE VIEWEmp_Dept AS SELECT * FROM Employee;
• D.UPDATE VIEWEmp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;

Which concurrency control method should be used only when conflicts between transactions rarely occur?

• A.Optimistic
• B.Serialization
• C.Time stamps
• D.Locking

A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

• A.Cust_Name is functionally dependent on Cust_I
• B.Cust_ID is transitively dependent on Cust_Name.
• C.Cust_Name is transitively dependent on Cust_ID.
• D.Cust_Name is the determinant.

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

A 1:1

• A.1:N
• B.N:1
• C.M:N

Consider the following relation definition:
STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK ON UPDATE
Which integrity constraint is violated in this relation definition?

• A.Enterprise constraint
• B.Referential integrity
• C.Entity integrity
• D.Domain constraint