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

Question 166

View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

A.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id) AND quantity_on_hand < 5;

B.SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;

C.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iUSING (product_id) AND quantity_on_hand < 5;

D.SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id)WHERE quantity_on_hand < 5;

Question 167

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.
Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

A.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

B.It displays prod IDs in the promos with the highest cost in the same time interval.

C.It displays prod IDs in the promos with the lowest cost in the same time interval.

D.It displays prod IDs in the promo with the lowest cost.

Question 168

Examine the data in the CUST NAME column of the CUSTOMERS table:
CUST_NAME
------------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?

A.WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,'') +1)) IN ('MC%','Mc%)

B.WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, '') +1)) LIKE UPPER('MC%')

C.WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,'') +1)) LIKE'Mc%'

D.WHERE SUBSTR(cust_name,INSTR(cust_name,'') +1) LIKE'Mc%' OR'MC%'

E.WHERE SUBSTR(cust_name, INSTR(cust_name,'') +1) LIKE'Mc%'

Question 169

View the Exhibit and examine the structure of the ORDERStable.

Which UPDATEstatement is valid?
UPDATE orders

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

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

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

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

Question 170

Examine the structure of the EMPLOYEES table.
NameNull?Type
---------------------- ------------
EMPLOYEE_IDNOT NULLNUMBER(6)
FIRST_NAMEVARCHAR2(20)
LAST_NAMENOT NULLVARCHAR2(25)
EMAILNOT NULLVARCHAR2(25)
PHONE NUMBERVARCHAR2(20)
HIRE_DATENOT NULLDATE
JOB_IDNOT NULLVARCHAR2(10)
SALARYNUMBER(8,2)
COMMISSION_PCTNUMBER(2,2)
MANAGER_IDNUMBER(6)
DEPARTMENT_IDNUMBER(4)
There is a parent/child relationship between EMPLOYEE_ID and 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_ID is 123.
Which query provides the correct output?

A.SELECT e.last_name, e.manager_idFROM employees e RIGHT OUTER JOIN
employees mon (e.employee_id = m.employee_id)WHERE e.employee_id = 123;

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

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

D.SELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN
employees mon (e.manager_id = m.employee_id)AND e.employee_id = 123;

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

Latest Upload: 282PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 412Nokia.4A0-113.v2026-05-01.q69; 439EC-COUNCIL.312-49v11.v2026-04-30.q214; 396Microsoft.MB-820.v2026-04-30.q101; 273Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 456NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 544EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 166

Question 167

Question 168

Question 169

Question 170

Download PDF File