Multiple choice technology databases

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?

  1. It returns employees who have 50% of the salary greater than $23,000:
  2. It returns employees who have 50% commission rate or salary greater than $23,000:
  3. It returns employees who have 50% of salary less than $23,000:

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The query uses OR operator: commission_pct = 0.5 OR salary > 23000. This returns employees who either have a 50% commission rate OR have a salary greater than $23,000. Option B correctly interprets this logic.

Keep practicing — related questions