Free Oracle 1Z0-083 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-083Join the discussion
Exam Name:	Oracle Database Administration II
Certification:	Oracle
Question Number:	283
Publish Date:	Jul 18, 2026
Rating 100%

Which three are true about SGA memory management in a multitenant database? (Choose three.)

A. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
B. SGA_MIN_SIZE cannot be set for a PDB.
C. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
D. The SGA_TARGET setting for a PDB cannot exceed 50%of the SGA_TARGET value of the root container.
E. The SHARED_POOL_SIZE setting for a PDB can be up to 80%of the SHARED_POOL_SIZE setting of the root container.
F. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

A. The control file is backed up whenever a new tablespace is created.
B. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
C. The control file is backed up whenever a new table is created.
D. The control file is backed up automatically each time the SPFILE is backed up manually.
E. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
F. It requires the use of fast recovery area (FRA).

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A. RMAN always includes tablespaces containing undo segments in the recovery set.
B. It can be performed using an auxiliary instance managed by RMAN.
C. It can be used to recover a dropped tablespace.
D. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
F. It can be used to recover a truncated table.
G. flashback database must be enabled for it to work.
H. It can be performed using an auxiliary instance managed by a DBA.

Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

A. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
B. It can be used for applications and middleware.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
D. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
E. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

Which three are true about the Oracle Optimizer? (Choose three.)

A. It can re-optimize execution plans after previous executions detect suboptimal plans.
B. It updates stale object statistics in the Data Dictionary.
C. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
D. It considers object statistics when generating execution plans for SQL statements.
E. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
F. It obeys all hints.

Add Comments