Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 17)

Question 76

Examine the following query:

What is the output of this query?

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

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

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

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

Question 77

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A.It produces an error because the ORDER BYclause should appear only at the end of a compound query-that is, with the last SELECTstatement.

B.It executes successfully but ignores the ORDER BYclause because it is not located at the end of the compound statement.

C.It produces an error because positional notation cannot be used in the ORDER BYclause with SET operators.

D.It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Question 78

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?
SELECT e.last_name, m.manager_id

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

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

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

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

Question 79

Examine the data in the NEW_EMPLOYEES table:

Examine the data in the EMPLOYEES table:

You want to:
1. Update existing employee details in the EMPLOYEES table with data from the NEW EMPLOYEES
table.
2. Add new employee detail from the NEW_ EMPLOYEES able to the EMPLOYEES table.
Which statement will do this:

A.MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

B.MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

C.MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

D.MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

Question 80

Evaluate the following statement.

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

A.They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Other Version: 1039Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File