ITPub博客

（420）Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?(Choose all that apply.)A. SORT_AREA_SIZEB. HASH_AREA_SIZEC. BITMAP_MERGE_AREA_SIZED. CREATE_BITMAP_AREA_SIZEE. PGA_AGGREGATE_TARGET答案：（A、B、C、...

（419）In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_TARGETB. Configuring Automatic Shared Memory ManagementC. Configuring Automatic Memory ManagementD. Setting a nonzero value for S...

（417）When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF. SORT_AREA_SIZE答案：（E）解析：查看各个参数是否为...

（416）To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor,you can set values for which of the following initialization parameters?(Choose all that apply.)A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF...

（415）For Oracle 11g,Oracle strongly recommends that you configure your database to use which of the following memory-management features?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Man...

（414）By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value,you will enable which of the following memory-management options?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Auto...

（413）Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Manual SGA M...

（412）Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between the capture and replay systemsB. When errors that occur in the capture system dont occur in the replay systemC. Top SQL statements...

（411）Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to restart one instance to begin workload capture.C. Specifically in RAC,you shut down all instances,restart them individually,and begi...

（410）Which of these recommendations should be followed before capturing a workload?(Choose all that apply.)A. Make sure your replay database has the same structure as the capture database,except without data.B. Make sure the replay and capture databases are similar in data content.C. Pe...

（409）Which of the following represents the correct sequence of events for Database Replay?A. Capture,analyze,preprocess,replayB. Capture,preprocess,analyze,replayC. Capture,preprocess,replay,analyzeD. Analyze,capture,preprocess,replayE. None of the above答案：（C）解析：...

（408）Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automatically implemented.B. Individual SQL Access Advisor recommendations can be scheduled for implementation.C. All SQL Access Advisor rec...

（407）Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?A. Create new indexes.B. Modify existing indexes.C. Implement partitioning on a nonpartitioned table.D. Create materialized views.E.All of the above答案：（E）解析：...

（406）Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor,with before and after metricsC. Graphs showing the actual performance imp...

（405）To view the results of a manual SQL Tuning Advisor task,which steps should the DBA take?A. From the Advisor Central home page,select the tuning task from the Advisor Tasks section.B. From Advisor Central,choose SQL Advisors,SQL Tuning Advisors,Manual Tuning Task Results.C. From Adv...

（404）When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?A. Filter versionsB. Filter loadsC. Filter tasksD. Filter options答案：（D）

（402）While querying the EMPLOYEES table,you receive an ORA-01578 message indicating block corruption in File#1201 and Block#1968.You analyze the table and the corruption is verified.Which RMAN command do you use to perform BMR and repair the corrupt block?（choose two)A. RECOVER FILE=12...

(401)Which of the following are correct about block media recovery?(Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B. Logical corruptions are repairable by BMR.C. Physical corruptions are repairable by BMR.D. RM...

（400）Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt blockD. RMANE. All of the above答案：（E）解析：《Backup and recovery user’s guid》 16.1.2.4...

（399）Which of the following is not an advantage of block media recovery(BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired.C. Datafiles remain online while corrupt blocks are repaired.D. A and C答案：（B）解析：《Backup and recovery user...