CIW Exam 1D0-541 Topic 4 Question 87 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 87
Topic #: 4

[All 1D0-541 Questions]

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;

Show Suggested Answer

Suggested Answer: C

by Dona at May 08, 2024, 08:42 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Leanora

7 months ago

Option A returns all employees. We need to filter for the sales department, so it's definitely C.

upvoted 0 times

...

Marshall

7 months ago

Did anyone consider option B? It specifies IDs but seems too limited.

upvoted 0 times

...

Theola

7 months ago

Yeah, C seems correct. It retrieves all details of employees from Dept_ID 022, which is sales.

upvoted 0 times

...

Luann

7 months ago

I guess the right answer is C, because it looks for employees in a specific department using Dept_ID.

upvoted 0 times

...

Elenor

7 months ago

It's a bit tricky. We need to focus on employees dismissed from the sales department.

upvoted 0 times

...

Meaghan

7 months ago

What do you think about the SQL question in the exam?

upvoted 0 times

...