niusouti.com

A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What

题目

A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?()

A. The keep pool is not configured.

B. Automatic Workarea Management is not configured.

C. Automatic Shared Memory Management is not enabled.

D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view


相似考题
更多“A senior DBA asked you to execute the following command to improve performance:SQL> ALT ”相关问题
  • 第1题:

    在使用画笔工具绘画过程中,增加、减小画笔硬度的快捷键是:

    A.Shift+“]”和Shift+“[”

    B.Ctrl(Pc)/Command(Mac)+“]”和Ctrl(Pc)/Command(Mac)+“[”

    C.Ctrl(Pc)/Command(Mac)+“>”和Ctrl(Pc)/Command(Mac)+“<”

    D.Alt(Pc)/Option(Mac)+“>”和Alt(Pc)/Option(Mac)+“<”


    参考答案:A

  • 第2题:

    当单击路径调板下方的"用画笔描边路径"图标时,若想弹出选择描边工具的对话框,应按住下列哪个键()

    A、Alt(Win)/Option(Mac)

    B、Ctrl(Win)/Command(Mac)

    C、Shift+Ctrl(Win)/Shift+Command(Mac)

    D、Alt+Ctrl(Win)/Option+Command(Mac)


    正确答案:A

  • 第3题:

    【单选题】当使用绘图工具时,如何暂时切换到吸管工具?

    A.按住Shift键

    B.按住Command(Mac)/Ctrl(Win)键

    C.按住Command+Option(Mac)/Ctrl+Alt(Win)键

    D.按住Option(Mac)/Alt(Win)键


    选择矩形或圆形后,按下Shift键,同时拖动鼠标便可得到正方形或圆形;选择某一个图形,同时按下Shift键,可以选择多个图形

  • 第4题:

    当使用绘图工具时,如何暂时切换到吸管工具?

    A.按住Shift键

    B.按住Command(Mac)/Ctrl(Win)键

    C.按住Command+Option(Mac)/Ctrl+Alt(Win)键

    D.按住Option(Mac)/Alt(Win)键


    参考答案:D

  • 第5题:

    【单选题】当使用绘图工具时,如何暂时切换到吸管工具?

    A.按住Option (Mac) / Alt (Win)键

    B.按住Command (Mac) / Ctrl (Win) 键

    C.按住Command + Option (Mac) / Ctrl + Alt (Win) 键

    D.按住Shift键


    选择矩形或圆形后,按下Shift键,同时拖动鼠标便可得到正方形或圆形;选择某一个图形,同时按下Shift键,可以选择多个图形

  • 第6题:

    【单选题】当单击路径调板下方的"用画笔描边路径"图标时,若想弹出选择描边工具的对话框,应按住下列哪个键?

    A.Alt(Win)/Option(Mac)

    B.Ctrl(Win)/Command(Mac)

    C.Shift+Ctrl(Win)/Shift+Command(Mac)

    D.Alt+Ctrl(Win)/Option+Command(Mac)


    A