Free Access Oracle.1Z0-082.v2022-07-18.q111 Practice Test (Page 9)

Question 36

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A.SELECT * FROM customers WHERE city = `D_%';

B.SELECT * FROM customers WHERE city LIKE `D_%';

C.SELECT * FROM customers WHERE city LIKE `D_';

D.SELECT * FROM customers WHERE city = `%D_';

Question 37

Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

A.The database opens after the roll forward phase of instance recovery has completed.

B.Only the CURRENT REDO log group is required to perform instance recovery.

C.It is always performed when opening a database.

D.No users can log on until instance recovery has completed.

E.It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.

F.It is guaranteed to complete within fast_start_mttr_target number of seconds.

Question 38

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

B.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

C.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

D.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

E.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

F.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Question 39

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL,
NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)

A.The second ROLLBACK command undoes the insert

B.The second ROLLBACK command replays the delete

C.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D.The second ROLLBACK command does nothing

E.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Question 40

Which two are true about complete recovery? (Choose two.)

A.The database must have FLASHBACK enabled in order to perform it.

B.Incremental backups can be used to roll forward the database while performing it.

C.Uncommitted transactions will be rolled back after it completes.

D.It is possible only when the database is in MOUNT state

E.Only RMAN backupsets can be used to restore a database as part of it.

Other Version: 2581Oracle.1Z0-082.v2023-08-24.q111; 1620Oracle.1Z0-082.v2023-03-31.q49; 5316Oracle.1Z0-082.v2022-03-27.q110; 6221Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 119Microsoft.MS-700.v2025-12-27.q286; 110SAP.C-BCFIN-2502.v2025-12-27.q12; 113SAP.C-BCBTM-2502.v2025-12-26.q9; 122SAP.C_THR89_2505.v2025-12-26.q45; 114SAP.C-BCBTM-2509.v2025-12-26.q10; 164IAPP.AIGP.v2025-12-25.q64; 146CISI.UAE-Financial-Rules-and-Regulations.v2025-12-25.q35; 177SAP.C-S4TM-2023.v2025-12-25.q82; 128EMC.D-VXR-DS-00.v2025-12-24.q43; 183Splunk.SPLK-5001.v2025-12-24.q37

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File