CIW
1D0-441 · Question #20
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…
The correct answer is C. SELECT *. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT *
- BSELECT ID, Last_Name
- CSELECT *
- DSELECT *
How the community answered
(17 responses)- A12% (2)
- B6% (1)
- C82% (14)
Community Discussion
No community discussion yet for this question.