Oracle.1Z0-051.175q(9)

OCP 11g 051题库

"COMPENSATION UNTIL DATE"

FROM employees;

What is the outcome?

A. It generates an error because the alias is not valid.

B. It executes successfully and gives the correct output.

C. It executes successfully but does not give the correct output.

D. It generates an error because the usage of the ROUND function in the expression is not valid.

E. It generates an error because the concatenation operator can be used to combine only two items.

Answer: C

QUESTION 18

Examine the structure of the PROMOTIONS table:

name Null Type

PROMO_ID NOT NULL NUMBER(6)

PROMO_NAME NOT NULL VARCHAR2(30)

PROMO_CATEGORY NOT NULL VARCHAR2(30)

PROMO_COST NOT NULL NUMBER(10,2)

The management wants to see a report of unique promotion costs in each promotion category.

Which query would achieve the required result?

A. SELECT DISTINCT promo_cost, promo_category FROM promotions;

B. SELECT promo_category, DISTINCT promo_cost FROM promotions;

C. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Answer: D

QUESTION 19

Evaluate the following query:

SELECT INTERVAL '300' MONTH,

INTERVAL '54-2' YEAR TO MONTH,

INTERVAL '11:12:10.1234567' HOUR TO SECOND

FROM dual;