Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in th

题目
Which two statements about the SQL Management Base (SMB) are true?()

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

相似考题

1.下列CASE语句中执行结果不为空的是()A、SELECTCASEWHEN125THEN'true'ELSE'false'END;B、SELECTCASEBINARY'B'WHEN'a'THEN1WHEN'b'THEN2END;C、SELECTCASEWHEN-10THEN'true'END;D、SELECTCASE'one'WHEN1THEN'one'WHEN2THEN'two'END;

2.A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

3.下列复选框构造方法，错误的是 ( )A．setLayout(new GridLayout(3，1))；B．add(new Checkbox("one"，null，true))；C．add(new Checkbox("two"))；D．add(new Checkbox("one"，true))；

4.Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);Which two statements are true?（）A. Database operations will be monitored only when they consume a significant amount of resource.B. Database operations for all sessions will be monitored.C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D. Only DML and DDL statements will be monitored for the session.E. All subsequent statements in the session will be treated as one database operation and will be monitored.

更多“Which two statements about the SQL Management Base (SMB) are true?() ”相关问题

  • 第1题：

    下列复选框构造方法，错误的是()。

    A．setLayout(newGridLayout(3,1));

    B．add(newCheckbox("one",null,true));

    C．add(newCheckbox("tWO");

    D．add(newCheckbox("one",true);


    正确答案：D

  • 第2题：

    About ________ of the workers in the factory were born in the ________.

    A.two-thirds, 1970 B.two-thirds, 1970s C.two-third,1970 D.two-third, 1970s


    正确答案：B

  • 第3题：

    32、S7-200提供了模拟电位器功能，使用哪些特殊存储器字节。（)

    A．SMB28-SMB29

    B．SMB29-SMB30

    C．SMB30-SMB31

    D．SMB31-SMB32


    D

  • 第4题：

    WhichcomponentoftheOraclenetworkingarchitectureprovidescharactersetanddatatypeconversionbetweendifferentcharactersetsontheclientandserver?()

    A.SQL*Plus

    B.OracleNet

    C.Two-TaskCommon（TTC）

    D.OracleProtocolSupport（OPS）


    参考答案：C

  • 第5题：

    12． About_______ of the workers in the factory were born in the __________．

    A． two- thirds;1970

    B． two- thirds ; 1970s

    C． two-third ; 1970

    D． two-third ; 1970s


    正确答案：B
    12．B【解析】句意：工厂里大约2/3的工人出生在20世纪70年代。分数的表达为分子用基数词，分母用序数词，如果分子大于1，则分母要用复数，排除C、D，年代的表达要在年份后加s．故选B。

  • 第6题：

    S7-200提供了模拟电位器功能，使用哪些特殊存储器字节。（)

    A．SMB28-SMB29

    B．SMB29-SMB30

    C．SMB30-SMB31

    D．SMB31-SMB32


    SMB28-SMB29

相关内容