Oracle.1Z0-051.175q(7)

OCP 11g 051题库

be labeled New Credit Limit. The column headings should have only the first letter of each word in

uppercase .

Which statement would accomplish this requirement?

A. SELECT cust_last_name Name, cust_credit_limit + 1000

"New Credit Limit"

FROM customers;

B. SELECT cust_last_name AS Name, cust_credit_limit + 1000

AS New Credit Limit

FROM customers;

C. SELECT cust_last_name AS "Name", cust_credit_limit + 1000

AS "New Credit Limit"

FROM customers;

D. SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000 INITCAP("NEW CREDIT LIMIT")

FROM customers;

Answer: C

QUESTION 13

View the Exhibit and examine the structure of the PRODUCTS table.

You need to generate a report in the following format:

CATEGORIES

5MP Digital Photo Camera's category is Photo

Y Box's category is Electronics

Envoy Ambassador's category is Hardware

Which two queries would give the required output? (Choose two.)

A. SELECT prod_name q'''s category is ' prod_category CATEGORIES FROM products;

B. SELECT prod_name q'['s ]'category is ' prod_category CATEGORIES FROM products;

C. SELECT prod_name q'\'s\' ' category is ' prod_category CATEGORIES FROM products;

D. SELECT prod_name q'<'s >' 'category is ' prod_category CATEGORIES FROM products;

Answer: CD

QUESTION 14

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount

in each income level. The report should NOT show any repeated credit amounts in each income level.

Which query would give the required result?

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