CIW

1D0-541

CIW v5 Database Design Specialist

https://killexams.com/pass4sure/exam-detail/1D0-541

Only an update anomaly would occur.
An insertion anomaly would occur.
A deletion anomaly would occur.
An update anomaly and a deletion anomaly would occur.

Answer: C

QUESTION: 121

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement? A.

Answer: C

QUESTION: 122

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?

Entity integrity
Domain constraint
Referential integrity
Enterprise constraint Answer: C QUESTION: 123

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?

Cust_Name is the determinant.
Cust_Name is transitively dependent on Cust_ID.
Cust_ID is transitively dependent on Cust_Name.
Cust_Name is functionally dependent on Cust_ID.

Answer: D

QUESTION: 124

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?

SELECT * FROM Employee;
SELECT ID, Last_Name
FROM Employee; WHERE ID = 0004;
SELECT * FROM Employee WHERE Dept_ID = 022;
SELECT *

FROM Employee WHERE Dept_ID = 022;