试题详情
- 单项选择题 The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）
A、all of the desired results
B、two of the desired results
C、one of the desired results
D、an error statement
- C
关注下方微信公众号，在线模考后查看
热门试题
- In the p
- NLS parameters can
- You executed&e
- 假设在一个表的3个字段NAME、SEX和
- Given： Which c
- Click the
- Which four are attri
- Which three
- You deploy&ens
- You have enabled bac
- Which of
- In which two aspects
- You work
- 命令sqlplus/nolog的作用是（
- You work
- 简单介绍OEM和OMS共同点和不同点？
- You need to change t
- The EMPLOYEES table
- You have a very larg
- EvaluatetheSQLstatem