1z0-083 Free Practice Test

Examine this output:

Which two are true? (Choose two.)

1. A. Any PDB not specified in the plan will be unable to execute statementsin parallel.
2. B. PDB3 can use all available parallel execution processes at times.
3. C. PDB1 is always limited to 40% of the available system resources regardless of demand.
4. D. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
5. E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
6. F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Correct Answer: AE

Which two are true about automatic block repair? (Choose two.)

1. A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
2. B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
3. C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
4. D. It is not possible for media corrupt blocks.
5. E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Correct Answer: BC

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

1. A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
2. B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
3. C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
4. D. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
5. E. CDB$ROOT and PDB$SEED are automatically duplicated.

Correct Answer: CD

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

1. A. ADDM can recommend shrinking the buffer cache.
2. B. ADDM can recommend extending the buffer cache.
3. C. By default, MMON creates an AWR snapshot every 30 minutes.
4. D. ADDM performs itsanalysis only when a DBA requests it.
5. E. By default, AWR snapshots are automatically purged after eight days.
6. F. AWR snapshots must be deleted when no longer required by ADDM.

Correct Answer: AEF

Your CDB has two regular PDBs as well as one application container with two applicationPDBs and an application seed
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

1. A. three
2. B. eight
3. C. seven
4. D. six
5. E. five

Correct Answer: C