Choose two. Which two are true about the SQL Tuning Advisor?

• A.It considers all SQL statements being analyzed by the advisor task as a group.
• B.It prevents performance regressions for SQL statements when changes are made.
• C.It can recommend semantic changes to SQL statements.
• D.It checks each query being analyzed for missing or stale statistics.
• E.It only recommends syntactic changes to SQL statements.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A.By default, AWR snapshots are automatically purged after eight days.
• B.ADDM can recommend extending the buffer cache.
• C.ADDM performs its analysis only when a DBA requests it.
• D.AWR snapshots must be deleted when no longer required by ADDM.
• E.ADDM can recommend shrinking the buffer cache.
• F.By default, MMON creates an AWR snapshot every 30 minutes.

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQLcode by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMINand AUDIT_VIEWERroles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

• A.Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
• B.Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
• C.An Oracle database can be restored from backup files copied using O/S utilities.
• D.Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• E.Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
• F.Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• G.Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

Comment: *

Name: *

Email: *

Verification: *