examine the code given below select employeeid from employees where commissionpct..., Oracle SQL 9i, 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 statement is correct with regard to this code?

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

/45

+ AnswerB

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 5466

Question: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?

A It returns employees who have 50% of the salary greater than $23,000:

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

C It returns employees who have 50% of salary less than $23,000:

D None of these above

B