Free CIW 1D0-541 Exam Questions

Become CIW Certified with updated 1D0-541 exam questions and correct answers

Page: 1 / 25

Total 125 Questions | Updated On: Aug 18, 2026

Add To Cart

Question 1

Which of the following best describes a composite key?

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

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

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

D : composite key is a primary or foreign key that consists of two or more attributes of a relation

Answer: D

Question 2

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

A : ERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);

B : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);

C : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

D : ERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Answer: D

Question 3

With regard to databases, what is normalization?

A : process of reducing the cardinality of a relation

B : process of organizing and refining relations

C : process of duplicating data to reduce the number of tables

D : process of limiting data stored in a table to a specific range of values

Answer: B

Question 4

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?

A : gical

B : ysical

C : nceptual

D : plementation

Answer: A

Question 5

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A : m

B : n

C : 1:1

D : 1:n

Answer: B

Page: 1 / 25

Total 125 Questions | Updated On: Aug 18, 2026

Add To Cart