You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()A. It may advise the use of online table redefinition for tables in dictionary managed

题目
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()

A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

C. It may advise the use of online table redefinition for tables in locally managed tablespaces

D. It will detect and advise about chained rows.

E. It may advise the use of segment shrink for free list managed tables.

相似考题

1.在数据封装中PDU的正确顺序是()。A.data，packet，frame，segment，BitB.data，packet，segment，frame，BitC.data，segment，frame，packet，BitD.data，segment，packet，frame，Bit

2.YouarecreatingaSQLTuningSettoallowagroupofSQLstatementstobepassedintotheSQLTuningAdvisor.WhichpackageswillyouusetocreatetheSQLTuningSet?()A.DBMS_WORKLOAD_REPOSITORYB.DBMS_RESOURCE_MANAGERC.DBMS_SQLTUNED.DBMS_ADVISOR

3.WhichpackageprovidesAPI’sfortheSQLTuningAdvisor?()A.DBMS_MONITORB.DBMS_STATSC.DBMS_SQLTUNED.DBMS_ADVISOR

4.ClicktheExhibitbutton.Given：11.<%com.example.Advisoradvisor=newcom.example.Advisor（）；%>12.<%request.setAttribute（"foo"，advisor）；%>Assumingtherearenoother"foo"attributesinthewebapplication，whichthreearevalidELexpressionsforretrievingtheadvicepropertyofadvisor？（）A.${foo.advice}B.${request.foo.advice}C.${requestScope.foo.advice}D.${requestScope[foo[advice]]}E.${requestScope["foo"]["advice"]}

更多“You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() ”相关问题

  • 第1题：

    Evaluatethefollowingcode：SQL>VARIABLEtask_nameVARCHAR2（255）；SQL>VARIABLEsql_stmtVARCHAR2（4000）；SQL>BEGIN：sql_stmt：=’SELECTCOUNT（*）FROMcustomersWHEREcust_state_province=’’CA’’’；：task_name：=’MY_QUICKTUNE_TASK’；DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，：task_name，：sql_stmt）；END；Whatistheoutcomeofthisblockofcode？（）

    A.Itcreatesataskandworkload，andexecutesthetask.

    B.Itcreatesataskandworkloadbutdoesnotexecutethetask.

    C.Itproducesanerrorbecauseatemplatehasnotbeencreated.

    D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.


    参考答案：A

  • 第2题：

    A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?()

    A. Data, Frame, Packet, Segment, Bit

    B. Data, Frame, Segment, Packet, Bit

    C. Data, Packet, Frame, Segment, Bit

    D. Data, Packet, Segment, Frame, Bit

    E. Data, Segment, Frame, Packet, Bit

    F. Data, Segment, Packet, Frame, Bit


    参考答案：F

  • 第3题：

    34、Spring配置文件中的＜beans＞元素下可以包含多个＜aop:config＞元素，一个＜aop:config＞元素中又可以包含属性和子元素，其子元素包括＜aop:pointcut＞、＜aop:advisor＞和＜aop:aspect＞。（）


    ACD

  • 第4题：

    变量的3个属性是( )。

    A．SEGMENT、OFFSET、TYPE

    B．SEGMENT、NEAR、TYPE

    C．SEGMENT、OFFSET、FAR

    D．WORD、OFFSET、TYPE


    正确答案：A

  • 第5题：

    下列选项中，哪个正确的描述了数据封装的顺序

    A．Data, frame, packet, segment, bit

    B．Segment, data, packet, frame, bit

    C．Data, segment, packet, frame, bit

    D．Data, segment, frame, packet, bit


    Data, segment, frame, packet, bit

  • 第6题：

    16、Spring配置文件中的＜beans＞元素下可以包含多个＜aop:config＞元素，一个＜aop:config＞元素中又可以包含属性和子元素，其子元素包括＜aop:pointcut＞、＜aop:advisor＞和＜aop:aspect＞。（）


    ACD

相关内容