CIW 1D0-541 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

Consider the symbols shown in the exhibit. Which of the following correctly identifies these

symbols when used in an entity-relationship (ER) diagram?

A1 = attribute, 2 = entity, 3 = relationship

B1 = entity, 2 = relationship, 3 = attribute

C1 = relationship, 2 = entity, 3 = attribute

D1 = relationship, 2 = attribute, 3 = entity

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A1 = attribute, 2 = entity, 3 = relationship

B1 = entity, 2 = relationship, 3 = attribute

C1 = relationship, 2 = entity, 3 = attribute

D1 = relationship, 2 = attribute, 3 = entity

0 / 1500

Question 2

Consider the Orders relation shown in the exhibit. Which of the following SQL statements

would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No

108 is listed?

AUPDATE Sales_Rep_No
IN Orders
SET(Sales_Rep_No = 110
WHERE Sales_Rep_No = 108);

BUPDATE Orders
SET Sales_Rep_No = 110
WHERE Sales_Rep_No = 108;

CUPDATE Orders
SET Sales_Rep_No = 110;

DUPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AUPDATE Sales_Rep_No
IN Orders
SET(Sales_Rep_No = 110
WHERE Sales_Rep_No = 108);

BUPDATE Orders
SET Sales_Rep_No = 110
WHERE Sales_Rep_No = 108;

CUPDATE Orders
SET Sales_Rep_No = 110;

DUPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;

0 / 1500

Question 3

A theta-join can be viewed as:

Athe intersection of two relations.

Ba Cartesian product of two relations.

Ca restricted Cartesian product of two relations.

Dthe Cartesian product of two union-compatible relations.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Athe intersection of two relations.

Ba Cartesian product of two relations.

Ca restricted Cartesian product of two relations.

Dthe Cartesian product of two union-compatible relations.

0 / 1500

Question 4

In which situation would the DBMS use a serial schedule to execute the transactions?

AConcurrent transactions read data from the same data structure.

BConcurrent transactions write data to different data structures.

CConcurrent transactions read or write the same data structure.

DConcurrent transactions read or write from different data structures.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AConcurrent transactions read data from the same data structure.

BConcurrent transactions write data to different data structures.

CConcurrent transactions read or write the same data structure.

DConcurrent transactions read or write from different data structures.

0 / 1500

Question 5

Consider the relations shown in the exhibit. Due to restructuring, the sales department has

been eliminated and the employees working in that department have been dismissed. All ID

information is stored as integers. Which SQL statement would be used to return a relation with all

information for the employees who have been dismissed?

ASELECT *
FROM Employee;

BSELECT ID, Last_Name
FROM Employee;
WHERE ID = 0004;

CSELECT *
FROM Employee
WHERE Dept_ID = 022;

DSELECT *
FROM Employee
WHERE Dept_ID = 022;

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT *
FROM Employee;

BSELECT ID, Last_Name
FROM Employee;
WHERE ID = 0004;

CSELECT *
FROM Employee
WHERE Dept_ID = 022;

DSELECT *
FROM Employee
WHERE Dept_ID = 022;

0 / 1500

Master CIW 1D0-541 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: