Which two are true about the Oracle dataabse methodology? (Choose two.)

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.Tuning activities should stop once the user is satisfied with performance.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.SQL statements should always be tuned before tuning any file systems.
• F.The alert log should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

• A.Poorly performing SQL statements can be tuned automatically by the Oracle server.
• B.SQL statements doing joins always do more physical I/O than single table queries.
• C.SQL statements doing only logical reads never require tuning because they do no physical I/O.
• D.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
• E.The solution that best optimizes one SQL statement can degrade the performance of others.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Flashback features? (Choose two.)

• A.FLASHBACK DROP can undrop an index when undropping a table.
• B.After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
• C.FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• D.FLASHBACK TABLE can undrop a column.
• E.FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Database Point-in-Time Recovery?

• A.The database must be in mount state when performing Database Point-in-Time Recovery.
• B.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• C.The database must be in archivelog mode.
• D.The database must have flashback database on to perform Database Point-in-Time Recovery.
• E.The database must be open resetlogs after Database Point-in-Time Recovery.
• F.The target point for the recovery must be specified as a time or System Change Number (SCN).

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *