Question No. 1

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

ASELECT *
FROM Customers
WHERE Satisfaction_Rate <= 80
OR Satisfaction_Rate >= 90;

BSELECT *
FROM Customers
WHERE Satisfaction_Rate IN (80 AND 90);

CSELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80
AND Satisfaction_Rate <= 89;

DSELECT *
FROM Customers
WHERE Satisfaction_Rate
BETWEEN (80, 90);

Show Answer

Correct Answer: C

Question No. 2

What is the highest normal form of the relation(s) shown in the exhibit?

ANo normal form

BSecond normal form

CFirst normal form

DThird normal form

Show Answer

Correct Answer: D

Question No. 3

Your company must choose which type of database to use for a new project. Which of the

following lists three characteristics of file-based database systems?

ARepetition of data, application program flexibility, and data centralization

BIncompatibility of files, tabular data structures, and data dependence

CSeparation of data, repetition of data, and data independence

DApplication program inflexibility, data dependence, and separation of data

Show Answer

Correct Answer: D

Question No. 4

Consider the following relational algebraic expression as well as the Dept1_Parts and

Dept2_Parts relations shown in the exhibit,

Which of the following relations would result from the given relational algebraic expression?

AOption A

BOption B

COption C

DOption D

Show Answer

Correct Answer: C

Question No. 5

Which statement best describes a procedural data manipulation language command?

AIt contains a query language for retrieving data.

BIt can be used only to manipulate data through a SQL interface.

CThe user is not required to know how the underlying data structures are implemented.

DIt requires that the user know how the underlying data structures are implemented.

Show Answer

Correct Answer: D

Free CIW 1D0-541 Exam Actual Questions

The questions for 1D0-541 were last updated On May 6, 2024