CIW v5 Database Design Specialist (1D0-541) - CIW Actual Exam Questions
Last updated on April 15, 2026
What is a domain?
A normalized set of data applicable to a particular relation
A combination of attributes for a relation
A definition of permissible values for one or more attributes
A set of permissible values for one or more relations
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What is the highest normal form of the relation(s) shown in the exhibit?
Third normal form
Second normal form
Boyce-Codd normal form
First normal form
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Consider the following SQL statement and the Orders relation shown in the exhibit: What is the output of this SQL statement?
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?
Degree of a relation
Cardinality of a relation
Primary key of a relation
Determinant of a relation
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following is a characteristic of the three-tier database architecture?
A Web browser is used as the application server.
The application logic is centralized on a dedicated server.
A thick client is used to perform business application logic functions locally.
Database application logic and database functionality are integrated and reside on a common server.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.