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

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A.SQL Performance Analyzer
• B.Database replay
• C.SQL Access Advisor
• D.Automatic Workload Repository compare reports
• E.SQL Tuning Advisor

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

• A.The primary key constraint on the EMPLOYEES table is disabled during redefinition.
• B.VPD policies are copied from the original table to the new table during online redefinition.
• C.All the triggers for the table are disabled without changing any of the column names or column types in the table.
• D.You must copy the VPD policies manually from the original table to the new table during online redefinition.

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

• A.Shut down the database instance.
• B.Restart the instance in normal mode.
• C.Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.
• D.Restart the database instance in UPGRADE mode.
• E.Restart the database Instance in RESTRICTED mode.
• F.Run the Database Migration Assistant.
• G.Set the MAX_STRING_SIZE parameter to EXTENDED.

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

• A.The DMU can report columns that are too long in the converted characterset.
• B.The release of the database to be converted can be any release since 9.2.0.8.
• C.The database to be migrated must be opened read-only.
• D.A DBAcancheck specific tables with the DMU
• E.The DMU can report columns that are not represented in the converted characterset.

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

• A.Oversized buffer cache
• B.High clustering factor for the indexes
• C.Undersized shared pool
• D.High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• E.Missing or stale histogram statistics