单项选择题

A.Run the SQL Access AdvisorB.Run the Memory Advisor fo……

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.
What would be your next step to improve performance（）

A.Run the SQL Access Advisor
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache

<上一题目录没有了>

热门试题

多项选择题WhichkindsoffailuresmaketheDataRecoveryAdvisor（DRA）generateamanualchecklist？（）

A.Failure when no standby database is configured
B.Failure because a data file is renamed accidentally
C.Failure that requires no archive logs to be applied for recovery
D.Failure due to loss of connectivity-for example， an unplugged disk cable

单项选择题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）

A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

单项选择题View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）

A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management （ASM） as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer （OUI）.
D.You are using General Purpose template and not the Custom Database template to create the database

多项选择题WhichstatementsaretrueregardingtheOracleDataPumpexportandimportoperations（）

A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported

多项选择题Whichstatementsaretrueaboutcheckpointing（）

A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files