Practice 1D0-541 Exam Online

Question 1

With regard to databases, what is normalization?

A : The process of reducing the cardinality of a relation

B : The process of organizing and refining relations

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

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

Answer: B

Question 2

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 : SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

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

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

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

Answer: A

Question 3

Which area of database security involves maintaining access to enterprise data?

A : Theft

B : Privacy

C : Availability

D : Confidentiality

Answer: C

Question 4

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

A : Implement a tabular structure.

B : Gather files in a distributed repository

C : Use a hierarchical database file system.

D : Tightly couple database structure to database application programs.

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:m

B : m:n

C : 1:1

D : 1:n

Answer: B

Name:	CIW Database Design Specialist
Exam Code:	1D0-541
Certification:	CIW Web Foundations
Vendor:	CIW
Total Questions:	125
Last Updated:	Apr 23, 2024

CIW 1D0-541