1z0-083 Free Practice Test

Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

1. A. Run the SQL Access Advisor.
2. B. Run the Memory Advisor for the shared pool.
3. C. Run the SQL Tunning Advisor.
4. D. Run theMemory Advisor for the Program Global Area.
5. E. Run the Memory Advisor for the System Global Area.

Correct Answer: B

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.

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

1. A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
2. B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
3. C. An Oracle database can be restored from backup files copied using O/S utilities.
4. D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
5. E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
6. F. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
7. G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Correct Answer: BDE

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

1. A. Data file 24 can be recovered only while connected to PDB2.
2. B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
3. C. Data file 24 can be restored only while connected toCDB$ROOT.
4. D. Data file 24 can be restored only while connected to PDB2.
5. E. Data file 24 can be recovered while connected to PDB2.
6. F. Data file 24 can be recovered while connected to CDB$ROOT.

Correct Answer: BCF

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

1. A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
2. B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
3. C. An existing Oracle base can be used.
4. D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
5. E. Existing Oracle Database instances must be shut down before starting the upgrade.
6. F. Only the grid user can perform the upgrade.

Correct Answer: DEF