ADDM
Memory Advisor
Segment Advisor
Undo Management
SQL Tuning Advisor
SQL Access Advisor
第1题:
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 Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D. Either B or C
第2题:
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()
第3题:
You create a master page named PageBase.master. The master page contains a Label control named lblTitle.You create a content page that references the master page.You need to change the Text property of the master page‘s lblTitle control from the content page.Which code segment should you use?()
A.
B.
C.
D.
第4题:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
第5题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第6题:
You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5. You create a folder named Dark in the App_Themes folder of the Web application. You also addfour skin files to this folder. You have to make sure that the controls on a page have their appearances overridden by the control definitions defined in the skin files. What should you do? Which Page directive should you use?()
第7题:
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()
第8题:
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.
第9题:
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output()
第10题:
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?()