Question 1

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

CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as

CUSTOMERS table.

CUSTOMERS need to be updated to reflect the latest information about the customers.

What is the error in the following MERGE statement?

Options :

A : The CUSTOMER_ID column cannot be updated.

B : The INTO clause is misplaced in the command.

C : The WHERE clause cannot be used with INSERT.

D : CUSTOMER_VU cannot be used as a data source.

Answer: A

Question 2

Examine the structure and data in the PRICE_LIST table:

You plan to give a discount of 25% on the product price and need to display the discount amount in

the same format as the PROD_PRICE.

Which SQL statement would give the required result?

Options :

A : SELECT TO_CHAR (prod_price* .25, ‘$99,999.99’)FROM PRICE_LIST

B : SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, ‘$99,999.00’)FROM PRICE_LIST

C : SELECT TO_CHAR (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’)FROM PRICE_LIST

D : SELECT TO_NUMBER (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’)FROM PRICE_LIST

Answer: C

Question 3

Examine the structure of the MEMBERS table:

NameNull?Type

------------------ --------------- ------------------------------

MEMBER_IDNOT NULLVARCHAR2 (6)

FIRST_NAMEVARCHAR2 (50)

LAST_NAMENOT NULLVARCHAR2 (50)

ADDRESSVARCHAR2 (50)

You execute the SQL statement:

SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM

members;

What is the outcome?

Options :

A : It fails because the alias name specified after the column names is invalid.

B : It fails because the space specified in single quotation marks after the first two column names is invalid.

C : It executes successfully and displays the column details in a single column with only the alias column heading.

D : It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.

Answer: D

Question 4

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:

SELECT DISTINCT quantity * unit_price total_paid FROM order_items ORDER BY ; Which two can replace so the query completes successfully?

Options :

A : quantity

B : quantity, unit_price

C : total_paid

D : product_id

E : quantity * unit_price

Answer: B,E

Question 5

Examine the following query:

SQL> SELECT prod_id, amount_sold

FROM sales

ORDER BY amount_sold

FETCH FIRST 5 PERCENT ROWS ONLY;

What is the output of this query?

Options :

A : It displays 5 percent of the products with the highest amount sold.

B : It displays the first 5 percent of the rows from the SALES table.

C : It displays 5 percent of the products with the lowest amount sold.

D : It results in an error because the ORDER BY clause should be the last clause.

Answer: C

Higher Test Marks with Free Online 1Z0-071 Exam Practice

Buying Options: