单选题View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?()A ADDM B Memory Advisor C Segment Advisor D Undo Management E SQL Tuning Advisor F SQL Access Advisor
单选题
View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?()
A
ADDM
B
Memory Advisor
C
Segment Advisor
D
Undo Management
E
SQL Tuning Advisor
F
SQL Access Advisor
参考解析
解析:
暂无解析
相关考题:
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.
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.
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 Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D. Either B or C
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?()A、You should use the page directive: %@ Page StyleSheetTheme="App_Themes.Dark"/B、You should use the page directive: %@ Page Theme="App_Themes.Dark"/C、You should use the page directive: %@ Page Theme="Dark"/D、You should use the page directive: %@ Page StyleSheetTheme="Dark"/
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()A、EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.B、EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.C、EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.D、Either B or CE、All of the above
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?()A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
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()A、An Automatic Workload Repository snapshot has been taken recently.B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
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 Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D、Either B or C
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?()A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?() A、 EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning AdvisorB、 EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorC、 EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?()A、set DB_FLASHBACK_RETENTION_TARGET=10800 B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
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 ResultsC、 From Advisor Central,choose SQL Advisors,Manual SQL Tuning Advisors,Tuning Task ResultsD、 Either B or C
You have a computer that runs Windows 7. You open Windows Internet Explorer and access a Web site asshown in the exhibit. (Click the Exhibit button.) You click the Suggested Sites button, but the suggestions failto display. You need to obtain suggested sites. What should you do?()A、From the Page menu, enable Caret Browsing.B、From the Safety menu, disable the SmartScreen Filter.C、From the Start menu, open a new Internet Explorer window.D、From the Microsoft Corporation Web site, refresh the Suggested Sites Web Slice.
You have a computer that runs Windows 7 and Windows Internet Explorer 8. You open Internet Explorerand access a Web site. The Web site displays a page that has misaligned text and graphic images. Youverify that the Web page displays correctly in previous versions of Internet Explorer. You need to view theWeb page correctly. What should you do?()A、Modify the text size.B、Enable Caret Browsing.C、Enable Compatibility View.D、Disable the SmartScreen Filter.
单选题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?()Athe alert.log fileBthe DBA_ALERTS viewCthe Database Control Home pageDthe Database Control performance pageEthe Database Control Maintenance page
单选题To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()AEM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.BEM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.CEM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.DEither B or CEAll of the above
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?()ASegment Advisor BSQL Tuning Advisor CSQL Access Advisor DSegment Resource Estimation EAutomatic Database Diagnostic Monitor (ADDM)
单选题The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?()Aset DB_FLASHBACK_RETENTION_TARGET=10800 Bcreate a new scheduler window for the time period of 24 hours and use the optimizer statistics Cmodify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings Dspecify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
单选题While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()A Memory AdvisorB Segment AdvisorC Undo AdvisorD SQL Tuning Advisor
单选题View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?()A ADDM B Memory Advisor C Segment Advisor D Undo Management E SQL Tuning Advisor F SQL Access Advisor
单选题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?()A SQL Tuning AdvisorB Undo AdvisorC ADDMD Memory Advisor
单选题To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()A EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning AdvisorB EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorC EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorD Either B or CE All of the above
单选题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()AAn Automatic Workload Repository snapshot has been taken recently.BThe non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.CThe threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.DThe threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
单选题Which version of a view would you use if you just want a quick, easy view within your XPage?()AData Table ControlBView ControlCRepeat ControlDFilter by category View Control
单选题To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()AFrom the Advisor Central home page, select the tuning task from the Advisor Tasks section.BFrom Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.CFrom Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.DEither B or C
单选题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 ResultsC From Advisor Central,choose SQL Advisors,Manual SQL Tuning Advisors,Tuning Task ResultsD Either B or C
单选题You have a computer that runs Windows 7 and Windows Internet Explorer 8. You open Internet Explorerand access a Web site. The Web site displays a page that has misaligned text and graphic images. Youverify that the Web page displays correctly in previous versions of Internet Explorer. You need to view theWeb page correctly. What should you do?()AModify the text size.BEnable Caret Browsing.CEnable Compatibility View.DDisable the SmartScreen Filter.