CIW Exam 1D0-541 Topic 1 Question 72 Discussion

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

Question #: 72
Topic #: 1

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 Bernardine at Jul 31, 2023, 01:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!