Oracle.1Z0-051.175q(8)

OCP 11g 051题库

FROM customers;

B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit"

FROM customers;

C. SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit"

FROM customers;

D. SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

Answer: C

QUESTION 15

View the Exhibit and examine the data in the CUSTOMERS table.

Evaluate the following query:

SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAX

LOWER LIMIT"

FROM customers;

The above query produces an error on execution.

What is the reason for the error?

A. An alias cannot be used in an expression.

B. The a lias NAME should not be enclosed with in double quotation marks .

C. The MIDPOINT+100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values.

D. The a lias MIDPOINT should be enclosed with in double quotation marks for the CUST_CREDIT_LIMIT/2 expression .

Answer: A

QUESTION 16

Evaluate the following query:

SQL> SELECT promo_name q'{'s start date was }' promo_begin_date

AS "Promotion Launches"

FROM promotions;

What would be the outcome of the above query?

A. It produces an error because flower braces have been used.

B. It produces an error because the data types are not matching.

C. It executes successfully and introduces an 's at the end of each promo_name in the output.

D. It executes successfully and displays the literal " {'s start date was } " for each row in the output.

Answer: C

QUESTION 17

View the E xhibit and examine the data in the EMPLOYEES table.

You want to generate a report showing the total compensation paid to each employee to date.

You issue the following query:

SQL>SELECT ename ' joined on ' hiredate

', the total compensation paid is '

TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)