examine the code given below select employeeid from employees where commissionpct..., ANSI 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 the above

/30

+ AnswerB

+ Report

Descriptive on ANSI SQL Ebook

Total Preview: 672

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 the above

B