최신Oracle Database 19c Performance and Tuning Management - 1Z0-084무료샘플문제

A. Oracle Automatic Reoptimization

B. Oracle SQL Performance Management

C. Database Resource Manager

D. Oracle SQL Tuning Advisor

E. Oracle Scheduler

A. AWR- snapshots in all pluggable databases will be purged automatically after every 60 mins.

B. AD DM is enabled for all pluggable databases.

C. AWR snapshots can be purged manually in pluggable databases.

D. ADDM, AWR, and ASH reports can be purged automatically.

A. One or more results were aged out of the result cache.

B. A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.

C. A request was made by the RCBG background of a non-RAC database.

D. result_cache_max_size is set dynamically to 0.

E. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

A. Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.

B. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

C. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

D. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

E. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

A. Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.

B. Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
/awrload into the AWR repository.

C. Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from the Statspack repository and import it by using impdp into the AWR repository.

D. Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.

A. Set DB_FLASH_CACHE_SIZE parameter to 192G.

B. Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G.

C. Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.

D. Disable Automatic Memory Management and set SGA_TARGET to 256G.

E. Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.