examine the code given below select employeeid from employees where commissionpct..., SQL, Databases

Test
- Model Test
Index

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

A It returns employees whose salary is 50% more than $23,000 
B It returns employees who have 50% commission rate or salary greater than $23,000 
C It returns employees whose salary is 50% less than $23,000 
D None of these above

/98

+ AnswerB

+ Report

Descriptive on SQL Ebook

Total Preview: 930

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

A It returns employees whose salary is 50% more than $23,000

B It returns employees who have 50% commission rate or salary greater than $23,000

C It returns employees whose salary is 50% less than $23,000

D None of these above

B