Oracle.1Z0-051.175q(3)

OCP 11g 051题库

A. CREATE VIEW v3

AS SELECT * FROM SALES

WHERE cust_id = 2034

WITH CHECK OPTION;

B. CREATE VIEW v1

AS SELECT * FROM SALES

WHERE time_id <= SYSDATE - 2*365

WITH CHECK OPTION;

C. CREATE VIEW v2

AS SELECT prod_id, cust_id, time_id FROM SALES WHERE time_id <= SYSDATE - 2*365

WITH CHECK OPTION;

D. CREATE VIEW v4

AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES

WHERE time_id <= SYSDATE - 2*365

GROUP BY prod_id, cust_id

WITH CHECK OPTION;

Answer: AB

QUESTION 3

You need to extract details of those products in the SALES table where the PROD_ID column contains

the string '_D123'.

Which WHERE clause could be used in the SELECT statement to get the required output?

A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'

B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'

C. WHERE prod_id LIKE '%_D123%' ESCAPE '%_'

D. WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'

Answer: B

QUESTION 4 Which two statements are true regarding single row functions? (Choose two.)

A. They a ccept only a single argument.

B. They c an be nested only to two levels.

C. Arguments can only be column values or constants.

D. They a lways return a single result row for every row of a queried table.

E. They c an return a data type value different from the one that is referenced.

Answer: DE

QUESTION 5

Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)

A. SELECT TO_CHAR(1890.55,'$0G000D00')

FROM DUAL;

B. SELECT TO_CHAR(1890.55,'$9,999V99')