Online Access Free 1z1-064 Practice Test

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.
Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A.DBA_THRESHOLDS
• B.DBA_ALERT_HISTORY
• C.DBA_ACTIVE_SESSION_HISTORY
• D.Oracle Enterprise Manager Cloud Control
• E.the alert log
• F.DBA_OUTSTANDING_ALERTS

You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.
Examine the parameters set for the instance:

Which two statements are true?

• A.A better execution plan may be found for the SQL statements and can be evolved manually.
• B.New SQL plan baselines might be generated automatically for the repeatable SQL statements.
• C.New execution plans generated will always be added to the SQL plan baselines as fixed plans.
• D.New execution plans cannot be evolved until execution plans from the previous version are dropped.
• E.New execution plans generated will always be added to the SQL plan baselines as accepted plans.

You have been asked to use table compression for two large tables. Given are the details of the tables:
The TRANS_DET table:
The table is used by an OLTP application.
High volume insert and update operations are performed on the table.
The table is frequently queried using index range scans.
The TRANS_HISTORY table:
The table is used by a DSS application.
High volume bulk loads are performed on the table.
The table is used to store archival data on which large table full-table scans (FTS) are performed.
Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)

• A.basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY table
• B.basic table compression for both the tables
• C.warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table
• D.advanced row compression for both the tables
• E.basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET table

In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.
Which two statements are true? (Choose two.)

• A.Alert settings for the warning and critical levels must be disabled before taking the USERS tablespace offline.
• B.Alerts are recorded in both Oracle Enterprise Manager Cloud Control and DBA_OUTSTANDING_ALERTS only when the critical threshold is exceeded.
• C.Alerts that are triggered are automatically recorded in DBA_ALERT_HISTORY after they are cleared.
• D.Alerts are triggered when the space usage reaches the warning level, again when it reaches the critical level, and yet again when the space usage falls below the critical level.

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.Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
• B.Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.
• 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_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.