1z0-083 Free Practice Test

Which three are true about Database Point-in-Time Recovery? (Choose three.)

1. A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
2. B. Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
3. C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
4. D. The Database must be in ARCHIVELOG mode.
5. E. The target point for the recovery must bespecified as a stime or System Change Number (SCN).
6. F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

Correct Answer: BDF
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database point-in%

Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

1. A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
2. B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
3. C. After the change, only one undo tablespace can exist in CDB$ROOT.
4. D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
5. E. Undo tablespaces existing in PDBs must be dropped before the change.
6. F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Correct Answer: BC
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

1. A. Increase the size of tape I/O buffers.
2. B. Disable FORCE LOGGING for the database.
3. C. Increase the size of the database buffer cache.
4. D. Enable asynchronous disk I/O.
5. E. Increase the level of RMAN multiplexing.

Correct Answer: DE

Which three are true In Oracle 19c and later releases?

1. A. Tablespaces always remain In read/write mode during transportable tablespace operations.
2. B. Simultaneous data pump jobs can be limited at thepluggable database (PDB) level.
3. C. Tablespaces never remain In read/write mode during transportable tablespace operations.
4. D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
5. E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
6. F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.

Correct Answer: ADE

Which three are true about opatchauto? (Choose three.)

1. A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
2. B. It must be invoked by a user with root user privileges.
3. C. Patches are appliedvia opatchauto.
4. D. Users must always input patch plans to opatchauto.
5. E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
6. F. It applies patches in nonrolling mode by default.
7. G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Correct Answer: ABC