Online Access Free 1Z1-083 Exam Questions

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
• B.V$SESSION_EVENT
• C.V$SESSION_WAIT
• D.V$SESSTAT
• E.V$SESSION_WAIT_CLASS

To schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered.
Both the databases are open. You execute the RMAN commands:
RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG
rcll/pwdcatll@ractll
Which two tasks are performed as part of the import?

• A.Imported databases are unregistered from the RC11 catalog.
• B.Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• C.Recovery catalog is resynchronized with the control files of the registered databases.
• D.All databases registered in the RC11 catalog are registered in the RC12C catalog.
• E.Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

• A.using the KEEP FOREVER clause with the BACKUP command
• B.using RMAN stored scripts
• C.creating customized reports about a single database's backups
• D.using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past
• E.creating encrypted backups
• F.using the REPORT SCHEMA command to list a database's current data files and tablespaces

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A.SBT tape compression and RMAN backup compression should be used in parallel.
• B.SBT tape compression can be used even if no RMAN compression is configured.
• C.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• D.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
• E.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

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

• A.Run the SQL Tunning Advisor.
• B.Run the Memory Advisor for the Program Global Area.
• C.Run the Memory Advisor for the System Global Area.
• D.Run the SQL Access Advisor.
• E.Run the Memory Advisor for the shared pool.