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

Examine the structure of the EMPLOYEES table.

EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.

Which two actions should you perform to make the cursor bind aware? (Choose two.)

• A.Regather statistics on the table.
• B.Create an index on the DEPARTMENT_ID column.
• C.Execute the query with the same DEPARTMENT_ID value multiple times.
• D.Change the default CURSOR_SHARING value to FORCE.
• E.Create a histogram on the DEPARTMENT_ID column.
• F.Gather statistics for the index.

Which two statements are true about server-generated alerts? (Choose two.)

• A.They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.
• B.They can be generated for user-defined metric thresholds.
• C.They are always logged in the alert log.
• D.They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.
• E.They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.

Which two statements are true about wait events?

• A.Wait events for an instance include statistics for both background and foreground processes.
• B.Wait event countries are incremented by the server process that waits.
• C.A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.
• D.Wait event statistics are cumulatively collected only at the instance level.
• E.A wait event can be defined in multiple wait classes.

Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views. You notice that some queries are performing poorly because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

• A.Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
• B.Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
• C.Create a SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate recommendations about query rewrite and fast refresh for materialized views.
• D.Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
• E.Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.

Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

• A.DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.
• B.Reducing DB time allows a database instance to support more user requests by using the same resources.
• C.DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
• D.DB time includes the time spent on client processes and background processes.
• E.DB time is always greater than or equal to the DB CPU time.