CIW 1D0 541
Q: 1
Which of the following definitions applies to all types of databases?
Options
Q: 2
The exhibit shows a relation for a companys projects. Which candidate key(s) would best
serve as the primary key for this relation?
Options
Q: 3
Consider the Registration relation shown in the exhibit. Which of the following SQL
statements would return the Registration2 relation from the Registration relation?
Options
Q: 4
Consider the following relations shown in the exhibit. Which of the following SQL statements would
return the Customers2 relation from the Customers relation?
Options
Q: 5
Which of the following best describes the ON DELETE CASCADE referential integrity
constraint?
Options
Q: 6
What is the highest normal form of the relation(s) shown in the exhibit?
Options
Q: 7
What is the highest normal form of the relation(s) shown in the exhibit?
Options
Q: 8
Consider the following database information:
domain s_id: integer
domain grd: fixed length character string length 1
STUDENT_GRADE(
Student_Number: s_id NOT NULL
Grade: grd )
Primary Key Student_Number
During which phase of the database design process would this information be developed?
Options
Q: 9
Consider the relation shown in the exhibit. Which of the following SQL statements would
properly add information for a new employee?
Options
Q: 10
In a relational database, which term describes a single table consisting of rows and columns?
Options
Question 1 of 10
