Question 1

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 2

You need to display the date 11-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’. Which SQL statement would give the required result?

Options :

A : SELECT TO_CHAR(TO_DATE(’11-oct-2007’), ‘fmDdthsp “of” Month, Year’)FROM DUAL;

B : SELECT TO_CHAR(‘11-oct-2007’, ‘fmDdspth “of” Month, Year’)FROM DUAL;

C : SELECT TO_CHAR(TO_DATE(‘11-oct-2007’), ‘fmDdspth of month, year’)FROM DUAL;

D : SELECT TO_DATE(TO_CHAR(’11-oct-2007’), ‘fmDdspth “of” Month, Year’))FROM DUAL;

Answer: A

Question 3

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:

SELECT first_name, department_id, salary

FROM employees

ORDER BY department_id, first_name, salary desc;

Which two statements are true regarding the result? (Choose two.)

Options :

A :

The values in the SALARY column would be returned in descending order for all employees having

the same value in the DEPARTMENT_ID and FIRST_NAME column.

B :

The values in the FIRST_NAME column would be returned in ascending order for all employees

having the same value in the DEPARTMENT_ID column.

C :

The values in the SALARY column would be returned in descending order for all employees having

the same value in the DEPARTMENT_ID column.

D : The values in all columns would be returned in descending order.

E :

The values in the FIRST_NAME column would be returned in descending order for all employees

having the same value in the DEPARTMENT_ID column.

Answer: A,B

Question 4

Which two are true about the NVL, NVL2, and COALESCE functions?

Options :

A : The first expression in NVL2 is never returned.

B : NVL2 can have any number of expressions in the list.

C : COALESCE stops evaluating the list of expressions when it finds the first null value.

D : COALESCE stops evaluating the list of expressions when it finds the first non-null value.

E : NVL must have expressions of the same data type.

F : NVL can have any number of expressions in the list.

Answer: D,E

Question 5

Examine this query and its output:

Examine this query with an incomplete was WHERE clause:

Which two are true about operators that can be used In the WHERE clause?

Options :

A : Using not in or <> any will give the same result.

B : Using in will display all the product names

C : Using not in or <> all will give the same result

D : Using <> any will display all the product names except the product named Fork

E : Using <> any will display all the product names.

Answer: C,D

Free 1Z0-071 Mock Exam – Practice Online Confidently

Buying Options: