Free Oracle 1Z0-083 Exam Dumps Questions & Answers

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

• A.V$SESSION_WAIT_CLASS
• B.V$SESSTAT
• C.V$SESSION
• D.V$SESSION_EVENT
• E.V$SESSION_WAIT

Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)

• A.If an RMAN command fails, the output will only identify the command that failed.
• B.If an RMAN command fails, the output will identify the channel ID where the failure occurred.
• C.Media Management errors appear as a line with "Additional information" and a number.
• D.Media Management errors appear as a line with "sbtio".
• E.Media Management errors appear as a line with "sbtio" and a number.
• F.Some messages in the error stack are not errors.

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

• A.cloning a remote container database in interactive mode
• B.relocating a remote pluggable database in interactive mode
• C.cloning a remote pluggable database in silent mode
• D.relocating a remote pluggable database in silent mode
• E.cloning a remote container database in silent mode
• F.relocating a remote container database in interactive mode
• G.relocating a remote container database in silent mode

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

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

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

• A.An application root PDB is created for APP1.
• B.Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• C.Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.
• D.A default service is created for the application root APP1.
• E.An application seed PDB is created for APP1.
• F.APP1 can never be unplugged.