CIW 1D0-541 CIW v5 Database Design Specialist Exam Practice Test

Page:    1 / 14   
Total 128 questions

Question 1

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

What is the output of this SQL statement?



Answer : C

Question 2

Consider the following relation definitions:

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 )

Primary Key Student_Number

HOUSING(

Housing_ID: integer NOT NULL

Student_Number: integer NOT NULL

Building: variable length character string length 25 )

Primary Key Housing_ID

Foreign Key Student_Number References STUDENT(Student_Number)

ON DELETE NO ACTION

ON UPDATE CASCADE

What are the referential constraints for the relations defined in these relation definitions?



Answer : D

Question 3

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?



Answer : C

Question 4

Which characteristic is an advantage of a database management system?



Answer : C

Question 5

Which of the following best describes a composite key?



Answer : D

Page:    1 / 14   
Total 128 questions