Free Access Oracle.1Z1-083.v2022-05-30.q253 Practice Test (Page 5)

Question 16

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

A.The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously

B.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

C.SBT tape compression and RMAN backup compression should be used in parallel.

D.SBT tape compression can be used even if no RMAN compression is configured.

E.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Question 17

You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

A.The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

B.The insert on USER2.DEPT fails because of the active transaction in the parent container.

C.The inserts on USER1.EMP were committed when the session connected to PDB2.

D.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

E.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

F.The inserts on USER1.EMP were rolled back when the session connected to PDB2.

G.The insert on USER2.DEPT is uncommitted.

Question 18

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

A.Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

B.If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.

C.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

D.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

E.Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

F.Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using asynchronous I/O/

G.Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.

Question 19

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

A.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

B.All non-Oracle files in the current FRA that have not been backed up already, are backed up.

C.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

D.All Oracle recovery files in the current fast recovery area (FRA) are backed up.

E.These backups can be written to disk or SBT.

Question 20

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

A.Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

B.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

C.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

D.Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

E.Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.

Other Version: 2008Oracle.1Z1-083.v2024-01-08.q225; 3739Oracle.1Z1-083.v2022-11-09.q168; 3881Oracle.1Z1-083.v2022-01-24.q140; 88Oracle.Examboosts.1Z1-083.v2021-11-12.by.lance.121q.pdf

Latest Upload: 142Fortinet.NSE7_SSE_AD-25.v2026-09-05.q85; 192Microsoft.PL-400.v2026-09-05.q375; 303Snowflake.DEA-C01.v2026-09-04.q215; 195HP.HPE0-V27.v2026-09-04.q127; 292NAHQ.CPHQ.v2026-09-03.q481; 125SAP.C-S4CPB-2602.v2026-09-02.q7; 139Cisco.700-805.v2026-09-02.q86; 174MSSC.CLT-4.0.v2026-09-02.q43; 137Fitness.NCSF-CPT.v2026-09-02.q18; 206Google.Generative-AI-Leader.v2026-09-02.q77

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File