Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 12)

Question 51

View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.)

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

A.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;

B.SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT
order_date FROM orders WHERE customer_id = 101);

C.SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101);

D.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);

Question 52

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.listing of customers who do not have a credit limit and were born before 1980

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

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

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

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

Question 53

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’,
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;
UPDATE orders

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

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

Question 54

Which two are true about using constraints?

A.A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

B.A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

C.A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

D.PRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

E.NOT NULL can be specified at the column and at the table level.

F.A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

Question 55

In which three situations does a transaction complete? (Choose three.)

A.when a PL/SQL anonymous block is executed

B.when a DELETE statement is executed

C.when a ROLLBACK command is executed

D.when a data definition language (DDL) statement is executed

E.when a TRUNCATE statement is executed after the pending transaction

Other Version: 2208Oracle.1z0-071.v2025-03-22.q314; 5996Oracle.1z0-071.v2024-10-24.q196; 2444Oracle.1z0-071.v2023-10-02.q276; 2333Oracle.1z0-071.v2023-05-08.q154; 6179Oracle.1z0-071.v2022-09-21.q298; 24728Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 144HRCI.aPHRi.v2025-12-22.q195; 107APICS.CSCP.v2025-12-22.q352; 107SAP.C_SIGPM_2403.v2025-12-22.q25; 114Nutanix.NCP-CI-Azure.v2025-12-22.q27; 106EMC.D-PEMX-DY-23.v2025-12-22.q45; 113SAP.C_S4CS_2502.v2025-12-22.q29; 115ISA.ISA-IEC-62443.v2025-12-22.q112; 175HashiCorp.HCVA0-003.v2025-12-20.q102; 128SAP.C_SAC_2501.v2025-12-20.q21; 112Snowflake.DAA-C01.v2025-12-20.q172

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File