Question 1
Which of the following occurs in a relation when records are added or removed?
Correct Answer:
D. The degree of the relation is fixed but the cardinality varies.
Free CIW v5 Database Design Specialist 1D0-541 Exam Questions
Question 2
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?
Correct Answer:
A. Logical
Question 3
The exhibit shows a table called Student Relation that tracks all information related to a
students courses, professors and sites. What would be the consequence of removing all records for
a student with the ID 1311?
Correct Answer:
C. A deletion anomaly would occur.
Question 4
Consider the Orders relation shown in the exhibit. Which of the following SQL statements
would return all complete tuples for order dates in 2002, arranged by amount from lowest to
highest?
Correct Answer:
D. SELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;
Question 5
Consider the Information Engineering diagram in the exhibit showing a conceptual data model
of the relations BUILDING and RESIDENT. What is the next step in refining the data model?
Correct Answer:
B. Create a logical data model.
Question 6
Consider the following four database design activities:
1 - Design user views.
2 - Select a DBMS.
3 - Apply normalization.
4 - Determine entities.
Which choice shows the correct ordering of these activities, from first to last, by assigned
numbers?
Correct Answer:
D. 4, 2, 3, 1
Question 7
Consider the Project relation shown in the exhibit as well as the following SQL statement:
DELETE FROM Project
WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?
Correct Answer:
A. Option A
Question 8
Consider the following relations shown in the exhibit. Which of the following SQL statements
would return the Customers2 relation from the Customers relation?
Correct Answer:
C. SELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80
AND Satisfaction_Rate <= 89;
Question 9
What is a domain?
Correct Answer:
C. A definition of permissible values for one or more attributes
Question 10
Consider the following SQL statement and the Orders relation shown in the exhibit:
What is the output of this SQL statement?
Correct Answer:
D. Option D