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

Comment: *

Name: *

Email: *

Verification: *

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

• A.It is not possible for media corrupt blocks.
• B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• 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.
• D.Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
• E.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about patchsets?

• A.They can be applied in a rolling fashion for Clusterware and the databases.
• B.Installing a patchset is considered an "upgrade."
• C.They are only released quarterly.
• D.They are installed via OPatch or OPatchAuto.
• E.They can introduce new features.
• F.A base release is not needed to install patchsets.

Comment: *

Name: *

Email: *

Verification: *

Which four are true about RMAN backup sets?

• A.A data file can be split into multiple sections stored in different backup sets.
• B.A backup piece can belong to only one backup set.
• C.A backup set can contain only one backup piece.
• D.Blocks from multiple data files can be contained in one backup piece.
• E.Blocks from multiple data files can be contained in one backup set.
• F.A backup set must be written to media.
• G.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• H.A backup set must be written to disk.

Comment: *

Name: *

Email: *

Verification: *

choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

• A.An error is returned because the retention period cannot be reduced.
• B.All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
• C.All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
• D.All historical data older than two years, if any, is purged from the flashback archive FDA1.

Comment: *

Name: *

Email: *

Verification: *