CIW 1D0-541 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1D0-541
Exam Name/Title: CIW v5 Database Design Specialist
Certification Provider: CIW
Corresponding Certification: CIW Other Certification

Exam Questions: 124
Updated On: Sep 27, 2026

Question #1

For the Employee relation shown in the exhibit, which set of column value holds the complete tuple for the employee named James Smith?

A. Emp_ID, 0002, First_Name, James, Last_Name, Smith

B. 0002, James, Smith

C. First_Name, James, Last_Name, Smith

D. 0002, James, Smith,10-25-76

Discussion 0

Correct Answer: D Vote an answer

Question #2

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?

A. 1NF, 2NF, 3NF and BCNF

B. 1NF, 2NF and 3NF

C. 1NF and 2NF

D. 1NF

Discussion 0

Correct Answer: C Vote an answer

Question #3

Which of the following definitions best describes an entity?

A. Data about data

B. An item about which information is stored

C. A relation

D. Data stored in a table column

Discussion 0

Correct Answer: B Vote an answer

Question #4

Which of the following occurs in a relation when records are added or removed?

A. The degree of the relation is fixed but the cardinality varies.

B. The cardinality of the relation is fixed but the degree varies.

C. The attributes in the domain change.

D. The number of domains changes.

Discussion 0

Correct Answer: A Vote an answer

Question #5

Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation? Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation?

A. (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No

B. Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

C. (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))

D. Customer X Sales_Rep

Discussion 0

Correct Answer: D Vote an answer

Question #6

A large enterprise uses a two-tier database architecture and runs complex database applications. Which term best describes the client in this system?

A. Fat client

B. Terminal client

C. Enterprise client

D. Thin client

Discussion 0

Correct Answer: A Vote an answer

Question #7

A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

A. Cust_Name is transitively dependent on Cust_ID.

B. Cust_Name is functionally dependent on Cust_I

C. Cust_ID is transitively dependent on Cust_Name.

D. Cust_Name is the determinant.

Discussion 0

Correct Answer: B Vote an answer

Question #8

Which security technique limits access by unauthorized users to parts of an enterprise database?

A. Concurrency

B. Integrity controls

C. Views

D. Locking

Discussion 0

Correct Answer: C Vote an answer

Question #9

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

A. DELETE * FROM Customers
WHERE Sales_Office = New York;

B. DELETE * FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York?

C. DELETE FROM Customers WHERESales_Office NOT LIKE ew York? WHERE Sales_Office NOT LIKE ?ew York?

D. DELETE FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York?

Discussion 0

Correct Answer: D Vote an answer

Question #10

Which of the following best describes a composite key?

A. A composite key is a primary key that consists of the first two attributes of a relation.

B. A composite key is a primary or foreign key defined by its parent keys.

C. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

D. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

Discussion 0

Correct Answer: C Vote an answer

Download Free CIW 1D0-541 Demo

Simply submit your e-mail address below to get started with our free demo of your CIW 1D0-541 exam.