Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It always analyzes all schemas in the database.
• B.It runs automatically every night by default.
• C.It can be run only manually.
• D.It is part of the DBMS_STATS package.
• E.It is part of the DBMS_ADVISOR package.
• F.It can recommend changes to improve the statistics gathering process.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about instance recovery?

• A.Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
• B.It is not possible if an archived log is missing.
• C.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
• D.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.
• E.It is performed by the Recovery Writer (rvwr) background process.
• F.It is performed automatically while the database remains in mount state. Then the database is opened.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

• A.Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
• B.After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
• C.The new extended data type capability must be enabled by running the utlrp.sql script
• D.The Oracle Application Express configuration should be updated after upgrading Oracle Database.
• E.Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

Comment: *

Name: *

Email: *

Verification: *

In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

• A.the number of tablespaces containing tables updated by a transaction
• B.the number of data files containing extents belonging to tables updated by a transaction
• C.poorly trained users who do not commit transactions
• D.issuing multiple savepoints during a transaction
• E.poorly written SQL

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *