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: Mar 25, 2025

Add To Cart

Question 1

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

A :

B :

C :

D :

Answer: D

Question 2

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 3

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

A : LECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

B : LECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

C : LECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D : LECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Answer: A

Question 4

What improvement can be made to file-based databases to overcome their limitations?

A : plement a tabular structure.

B : ther files in a distributed repository

C : a hierarchical database file system.

D : ghtly couple database structure to database application programs.

Answer: A

Question 5

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

Page: 1 / 25

Total 125 Questions | Updated On: Mar 25, 2025

Add To Cart