Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 50)

Question 241

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully?

A.SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY COUNT(*)> 10;

B.SELECT prod_id FROM sales WHERE quantity_sold> 55000 GROUP BY prod_id HAVING COUNT(*)> 10;

C.SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY prod_id HAVING COUNT(*)> 10;

D.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY prod_id;

E.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold> 55000;

Question 242

Refer to the exhibit.

Which two queries execute successfully?

A.SELECT * FROM products
UNION
SELECT * FROM new_products;

B.SELECT k FROM products
MINUS
SELECT prod_id FROM new_products;

C.SELECT prod_id, exp_date FROM products
UNION ALL
SELECT prod_id, NULL FROM new_products;

D.SELECT prod_id FROM products
UNION ALL
SELECT prod_id, prod_name FROM new_products;

E.SELECT prod_id, prod_name FROM products
INTERSECT
SELECT 100, prod_name FROM newproducts;

Question 243

Examine this SQL statement:

Which two are true?

A.The subquery is not a correlated subquery.

B.The UPDATE statement executes successfully even if the subquery selects multiple rows.

C.The subquery is executed before the UPDATE statement is executed.

D.The subquery is executed for every updated row in the ORDERS table.

E.All existing rows in the ORDERS table are updated.

Question 244

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

You want to select all employees having 100 as their MANAGER_ID manages and their manager.
You want the output in two columns: the first column should have the employee's manager's LAST_NAME and the second column should have the employee's LAST_NAME.
Which SQL statement would you execute?

A.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eWHERE m.employee_id = e.manager_id AND e.manager_id=100

B.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON e.employee_id = m.manager_idWHERE m.manager_id=100;

C.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE m.manager_id=100;

D.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE e.manager_id=100;

Question 245

Which three are true about multitable INSERTstatements? (Choose three.)

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

B.They can be performed on relational tables.

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

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.

Other Version: 4543Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 203PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 305Nokia.4A0-113.v2026-05-01.q69; 266EC-COUNCIL.312-49v11.v2026-04-30.q214; 230Microsoft.MB-820.v2026-04-30.q101; 213Salesforce.MC-202.v2026-04-30.q57; 208BICSI.INSTC_V8.v2026-04-29.q53; 340NMLS.MLO.v2026-04-28.q82; 245NCARB.Project-Management.v2026-04-28.q27; 466EMC.D-AV-DY-23.v2026-04-27.q184; 1126ServiceNow.CSA.v2026-04-27.q483

Question 241

Question 242

Question 243

Question 244

Question 245

Download PDF File