Transcription
CIW1D0-541CIW v5 Database Design ail/1D0-541
A. Only an update anomaly would occur.B. An insertion anomaly would occur.C. A deletion anomaly would occur.D. An update anomaly and a deletion anomaly would occur.Answer: CQUESTION: 121Consider the following SQL statement and the Orders relation shown in the exhibit:What is the output of this SQL statement?A.70
B.C.D.Answer: CQUESTION: 122Consider the following relation definition:STUDENT(Student Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student NumberHOUSING(Housing ID: integer NOT NULL Student Number: integer NOT NULLBuilding: variable length character string length 25 NOT NULL) Primary Key Housing IDForeign Key Student Number ReferencesSTUDENT(Student Number) ON DELETE NO CHECK ON UPDATEWhich integrity constraint is violated in this relation definition?A. Entity integrityB. Domain constraintC. Referential integrityD. Enterprise constraintAnswer: CQUESTION: 12371
A relation for a construction company is shown in the exhibit. Which of the following bestdefines the relationship between Cust ID and Cust Name?A. Cust Name is the determinant.B. Cust Name is transitively dependent on Cust ID.C. Cust ID is transitively dependent on Cust Name.D. Cust Name is functionally dependent on Cust ID.Answer: DQUESTION: 124Consider the relations shown in the exhibit. Due to restructuring, the sales department has beeneliminated and the employees working in that department have been dismissed. All IDinformation is stored as integers. Which SQL statement would be used to return a relation withall information for the employees who have been dismissed?72
A. SELECT * FROM Employee;B. SELECT ID, Last NameFROM Employee; WHERE ID 0004;C. SELECT * FROM EmployeeWHERE Dept ID 022;D. SELECT *FROM EmployeeWHERE Dept ID 022;Answer: C73
For More exams visit https://killexams.com/vendors-exam-listKill your exam at First Attempt.Guaranteed!
1D0-541 CIW CIW v5 Database Design Specialist 1
