Online Access Free 1z0-064 Practice Test

In which three scenarios would you recommend the use of the SQL Performance Analyzer?

• A.to analyze the impact of new indexes and materialized views on the SQL statements executed by an application
• B.to identify SQL statements whose performance may have regressed due to a hardware upgrade
• C.to identify SQL statements that require SQL profiles
• D.to analyze the impact of using bind variables for syntactically similar SQL statements
• E.to analyze the impact of network and interconnect changes on database workload
• F.to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c

Which three statements are true about the interpretation of an execution plan? (Choose three.)

• A.A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.
• B.The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.
• C.An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.
• D.A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.
• E.The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.

In which three situations can dynamic statistics be used? (Choose three.)

• A.when a query is on a partitioned table with a global index
• B.when extended statistics are not available for SQL statements that use complex predicates
• C.when the sampling time is a small fraction of the total time for a query
• D.when an execution plan is suboptimal because of complex predicates
• E.when index statistics are missing on a column that is used in SQL statements with highly selective filters

Examine an extract from a PGA Memory Advisory for your database:

Which two inferences are correct? (Choose two.)

• A.PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.
• B.The current PGA size requires the use of a temporary tablespace for sorting operations.
• C.Automatic management of PGA memory is disabled.
• D.The current PGA size is sufficient and does not require the memory manager to allocate more memory.

Examine the parameters set for your database instance:

You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.
Which two actions should you perform? (Choose two.)

• A.Set DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE to their minimum required values.
• B.Set the PGA_AGGREGATE_TARGET parameter to 0 and the SGA_TARGET parameter to 1.5G.
• C.Set the SGA_TARGET parameter equal to SGA_MAX_SIZE.
• D.Set the MEMORY_MAX_TARGET parameter to the sum of DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE.
• E.Set the SGA_TARGET parameter to the sum of DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE.