【2020年8月】Oracle OCP 071考试新题(-9题)CUUG内部题库

【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金牌名师亲自题库解析