试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- You are u
- View the E
- You own a table cal
- 假设emp表包含一个婚姻状况的字段，则应
- The database&e
- View the E
- The DBA issues this
- Which of t
- Given: Whatisthere
- Exhibit TheCOMMISSI
- To performQ
- You created&en
- The database&#
- You issued&ensp
- Given: Whatistheres
- View the E
- Your database&
- Examine the data of
- The RECYCLEBIN para
- 假设on delete cascade选