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

Which three statements are true about Automatic Workload Repository (AWR)?

• A.The AWR data is stored in memory and in t he database.
• B.AWR contains system wide tracing and logging information.
• C.All AWR tables belong to the SYSTEM schema.
• D.AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E.The snapshots collected by AWR are used by the self-tuning components in the database

Which three are true about Data Pump in an Oracle multitenant environment?

• A.It can be used to transport data from a PDB to a non-CDB.
• B.It can be used to transport data from a non-CDB to a PDB.
• C.It can be used to clone a CDB.
• D.It can be used to transport data between PDBs.
• E.It can be used to create a new PDB.

Which two are true about instance recovery? (Choose two.)

• A.It is not possible if an archived log is missing.
• B.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
• C.It is performed automatically while the database remains in MOUNT state. Then the database is opened.
• D.It is performed by the Recovery Writer (RVWR) background process.
• E.Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
• F.Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

• A.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
• B.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
• C.A table's constraints must be disabled before issuing the flashback.
• D.Row Movement must be enabled on the table being flashed back.
• E.A table's indexes must be set to unusable before issuing the flashback.