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

Question 41

View the Exhibit and examine the structure of the ORDERStable.

Which UPDATE statement is valid?
UPDATE orders

A.SET order_date = TO_DATE(’12-mar-2007’,’dd-mon-yyyy’),
SET order_total = TO_NUMBER (NULL)
WHERE order_id = 2455;

B.SET order_date = ’12-mar-2007’,
order_total IS NULL
WHERE order_id = 2455;
UPDATE orders

C.SET order_date = ’12-mar-2007’,
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;
UPDATE orders

D.SET order_date = ’12-mar-2007’,
order_total = NULL
WHERE order_id = 2455;
UPDATE orders

Question 42

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name
FROM customers
WHERE countryid=10
UNION
SELECT custid CUSTNO, cust_last_name
FROM customers
WHERE countryid=30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

A.ORDER BY CUSTNO

B.ORDER BY"CUST NO"

C.ORDER BY "Last Name"

D.ORDERBY2, 1

E.ORDER BY 2, cust_id

Question 43

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

A.SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

B.SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

C.SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

D.SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

E.SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

Question 44

Which three statements are true regarding group functions? (Choose three.)

A.They can be used on only one column in the SELECT clause of a SQL statement.

B.They can be used only with a SQL statement that has the GROUP BY clause.

C.They can be used on columns or expressions.

D.They can be used along with the single-row function in the SELECT clause of a SQL statement.

E.They can be passed as an argument to another group function.

Question 45

Which two statements are true about a self join? (Choose two.)

A.It can be a left outer join.

B.It must be a full outer join.

C.It can be an inner join.

D.It must be an equijoin.

E.The join key column must have an index.

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

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 220CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 183Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File