Online Access Free Oracle.1z0-071.v2022-02-07.q334 Practice Test (Page 8)

1z0-071 Exam Question 31

Which statement is true regarding the default behavior of the ORDER BY clause?

A.Numeric values are displayed in descending order if they have decimal positions.

B.Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

C.In a character sort, the values are case-sensitive.

D.NULLs are not included in the sort operation.

1z0-071 Exam Question 32

Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?

A.SELECT e.last_name, m.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.manager_id = m.employee_id)
AND e.employee_id = 123;

B.SELECT e.last_name, e.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;

C.SELECT m.last_name, e.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

D.SELECT e.last_name, m.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.employee_id = m.manager_id)
WHERE e.employee_id = 123;

1z0-071 Exam Question 33

Which three are true about multiple INSERT statements?

A.They can be performed only by using a subquery.

B.They can be performed on external tables using SQL*Loader.

C.They can be performed on relational tables.

D.They can insert each computed row into more than one table.

E.They can be performed on views.

F.They can be performed on remote tables.

1z0-071 Exam Question 34

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

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

A.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

B.listing of customers who do not have a credit limit and were born before 1980

C.finding the number of customers, in each city, whose marital status is 'married'.

D.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

E.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.

1z0-071 Exam Question 35

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

You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected property price, which is 115% of the property price. The stores displayed must have START_DATE in the range of 36 months starting from 01Jan-2000 and above.
Which SQL statement would get the desired output?
A)