ocp考试资料群：569933648 验证码：ocp ocp 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（486）
- postgresql（55）
- ocp 12c（175）
- ocp（102）
- 未分配的博文（154）
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2020-09-23 16:16:18
【2020年8月】oracle ocp 071考试新题(-9题)cuug内部题库
choose two.
examine the description of the employees table:
name null? type
------------------------------------------------------------------
employee_id not null number (3)
first_name varchar2 (15)
last_name not null varchar2 (15)
salary number(6,2)
which two queries will result in an error?
a) select first_name last_name
from employees;
b) select first_name, last_name
from employees;
c) select last_name, 12 * salary as annual_salary
from employees
where annual_salary > 100000
order by 12 * salary;
d) select last_name, 12 * salary as annual_salary
from employees
where annual_salary > 100000
order by annual_salary;
e) select last_name, 12 * salary as annual_salary
from employees
where 12 * salary > 100000
order by annual_salary;
f) select last_name, 12 * salary as annual_salary
from employees
where 12 * salary > 100000
order by 12 * salary;
2020年8月份oracle ocp 071考试新题(-9题)cuug内部题库，钉钉群(35277291)oracle金牌名师亲自题库解析