1z1-062 試験問題を無料オンラインアクセス

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?

• A.SQL Tuning Advisor
• B.Memory Advisor for the shared pool
• C.Memory Advisor for the PGA
• D.SQL Access Advisor

Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

• A.No redo and undo records are generated for temporary tables.
• B.Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
• C.Undo records for temporary tables are stored in a temporary tablespace.
• D.Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
• E.No redo is generated for the undo records belonging to temporary tables.

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

• A.Rebalance operations are completed faster than with a fixed extent size
• B.Resync operations are completed faster when a disk comes online after being taken offline.
• C.An ASM Instance automatically allocates an appropriate extent size.
• D.The metadata used to track extents in SGA is reduced.
• E.Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Examine the query and its output:

What might have caused three of the alerts to disappear?

• A.An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
• B.The database instance was restarted before the execution of the second query.
• C.The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
• D.An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.

Which statement is true about unified auditing?

• A.Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.
• B.Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
• C.The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
• D.The unified audit trail contains audit records only from unified audit policies and AUDIT settings.