单选题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 futu

题目
单选题
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

相似考题

1.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.

2.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

3. 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"/>

4.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.

更多“单选题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 futu”相关问题

  • 第1题：

    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 C
    • E、All of the above

    正确答案:D

  • 第2题：

    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 Advisor
    • B、 Segment Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:C

  • 第3题：

    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

    正确答案:A

  • 第4题：

    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 C
    • E、 All of the above

    正确答案:D

  • 第5题：

    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

    正确答案:A

  • 第6题：

    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.

    正确答案:C

  • 第7题：

    单选题
    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 C

    E

    All of the above


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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 C

    E

     All of the above


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Which version of a view would you use if you just want a quick， easy view within your XPage？（）
    A

    Data Table Control

    B

    View Control

    C

    Repeat Control

    D

    Filter by category View Control


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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 Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第14题：

    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.

    正确答案:C

  • 第15题：

    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 file
    • B、the DBA_ALERTS view
    • C、the Database Control Home page
    • D、the Database Control performance page
    • E、the Database Control Maintenance page

    正确答案:C

  • 第16题：

    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

    正确答案:D

  • 第17题：

    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.

    正确答案:C

  • 第18题：

    单选题
    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 file

    B

    the DBA_ALERTS view

    C

    the Database Control Home page

    D

    the Database Control performance page

    E

    the Database Control Maintenance page


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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?（）
    A

    Segment Advisor 

    B

    SQL Tuning Advisor 

    C

    SQL Access Advisor 

    D

    Segment Resource Estimation 

    E

    Automatic Database Diagnostic Monitor (ADDM)


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    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 Advisor

    B

     Segment Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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 Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

相关内容