36、
36.Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.) A. It repairs blocks that have read disk I/O errors. B. It checks whether the alias metadata directory and the file directory are linked correctly. C. It repairs blocks by always reading them from the mirror copy and writing them to the original location. D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Answer: AD 参考： Automatic Storage Management e18951 The remap command only relocates blocks. It does not correct or repair blocks that contain corrupted contents. The command uses a physical block size based on the SECTOR_SIZE disk group attribute. 答案A是错误的。
37、
37.During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation? A. The installation terminates with an error. B. The installation proceeds with the default value without warnings and errors. C. The installation proceeds with the default value but it would not be an OFA-compliant database. D. The installation proceeds with the default value but a message would be generated in the alert log file.
Answer: D
38、
38.The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task? A. statistics recommendations B. SQL Profile recommendations C. Index-related recommendations D. restructuring of SQL recommendations
Answer: B 参考：Performance Tuning Guide E41573-04 How Automatic SQL Tuning Works Tunes each SQL statement individually by calling SQL Tuning Advisor During the tuning process, the databaseconsiders and reports all recommendation types, but it can implement only SQL profiles automatically.
39、View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit?
A. Accept the recommended SQL profile. B. Collect statistics for the related objects. C. Run the Access Advisor for the SQL statement. D. Run the Segment Advisor for recommendations.
Answer: C
40、
40.Evaluate the following code: SQL>VARIABLE task_name VARCHAR2(255);
SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customers WHERE cust_state_province =''CA'''; :task_name := 'MY_QUICKTUNE_TASK'; DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name, :sql_stmt); END; What is the outcome of this block of code? A. It creates a task and workload, and executes the task. B. It creates a task and workload but does not execute the task. C. It produces an error because a template has not been created. D. It produces an error because the SQL Tuning Set has not been created.
Answer: A DBMS_ADVISOR 查询dba_advisor_definitions获得所有有效的顾问列表 ADVISOR_ID ADVISOR_NAME PROPERTY ADVISOR_ID 1 ADDM 1 1 2 SQL Access Advisor 271 2 3 Undo Advisor 1 3 4 SQL Tuning Advisor 935 4 5 Segment Advisor 67 5 6 SQL Workload Manager 0 6 7 Tune MView 31 7 8 SQL Performance Analyzer 935 8 9 SQL Repair Advisor 679 9 10 Compression Advisor 3 10 参考：Performance Tuning Guide E41573-04 Performing a Quick Tune To tune a single SQL statement, the QUICK_TUNEprocedure accepts as its input a task_nameand a SQL statement. The procedure creates a task and workload and executes this task. There is no difference in the results from using QUICK_TUNE. They are exactly the same as those from using EXECUTE_TASK, but this approach is easier to use when there is only a single SQL statement to be tuned. The syntax is as follows: DBMS_ADVISOR.QUICK_TUNE ( advisor_name IN VARCHAR2, task_name IN VARCHAR2, attr1 IN CLOB, attr2 IN VARCHAR2 := NULL, attr3 IN NUMBER := NULL, task_or_template IN VARCHAR2 := NULL );