Free Access Oracle.1z0-071.v2022-02-20.q161 Practice Test (Page 19)

Question 86

Examine the structure of the BOOKS_TRANSACTIONS table.

You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHERE clause to perform the required update?

A.MEMBER_ID = NULL;

B.MEMBER_ID = '';

C.MEMBER_ID IS NULL;

D.MEMBER_ID = "";

Question 87

Which statement is true about SQL query processing in an Oracle database instance?
(Choose the best answer.)

A.During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.

B.During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.

C.During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

D.During executing, the oracle server may read data from storage if the required data is not already in memory.

Question 88

Evaluate the following statement.
INSERT ALL
WHEN order_total < 10000 THEN
INTO small_orders
WHEN order_total > 10000 AND order_total < 20000 THEN
INTO medium_orders
WHEN order_total > 200000 AND order_total < 20000 THEN
INTO large_orders
SELECT order_id, order_total, customer_id
FROM orders;
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.

Question 89

Which two statements are true about Data Manipulation Language (DML) statements?

A.An INSERTINTO...VALUES..statement can add multiple rows per execution to a table.

B.An UPDATE... SET...statement can modify multiple rows based on multiple conditions on a table.

C.A DELETE FROM.....statement can remove rows based on only a single condition on a table.

D.An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

E.A DELETE FROM.....statement can remove multiple rows based on multiple conditions on a table.

F.An UPDATE....SET....statement can modify multiple rows based on only a single condition on a table.

Question 90

Examine the structure of the MEMBERStable:

You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?

A.SELECT * FROM MEMBERS WHERE state LIKE '%A_';

B.SELECT * FROM MEMBERS WHERE state LIKE 'A%';

C.SELECT * FROM MEMBERS WHERE state LIKE 'A_%';

D.SELECT * FROM MEMBERS WHERE state LIKE 'A_';

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; 6181Oracle.1z0-071.v2022-09-21.q298; 4978Oracle.1z0-071.v2022-08-30.q239; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 145HRCI.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; 116ISA.ISA-IEC-62443.v2025-12-22.q112; 175HashiCorp.HCVA0-003.v2025-12-20.q102; 129SAP.C_SAC_2501.v2025-12-20.q21; 112Snowflake.DAA-C01.v2025-12-20.q172

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File