nerdexam
IBM

C2090-610 · Question #136

C2090-610 Question #136: Real Exam Question with Answer & Explanation

Sign in or unlock C2090-610 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.

Question

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria: - The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. - The employee has attended university Which SQL statement will accomplish this?

Options

  • ASELECT * FROM employee
  • BSELECT * FROM employee
  • CSELECT * FROM employee
  • DSELECT * FROM employee

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.

Full C2090-610 Practice