IBM
C2090-610 · Question #137
C2090-610 Question #137: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?
Options
- ASELECT empno, hiredate, salary
- BSELECT empno, hiredate, salary
- CSELECT empno, hiredate, salary
- DSELECT empno, hiredate, salary
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.