多选题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?（）AIt may advise the use of online table redefinition for tables in dictionary manage

题目
多选题
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.You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space

2.You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL

3.You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。A、identify the segments that you should shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space

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.

参考答案和解析
正确答案： D,C
解析： 暂无解析
更多“多选题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?（）AIt may advise the use of online table redefinition for tables in dictionary manage”相关问题

  • 第1题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

    • A、 Top SQL
    • B、 snapshots
    • C、 SQL Tuning sets
    • D、 index access path
    • E、 optimizer statistics
    • F、 materialized view logs

    正确答案:A,C,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题：

    In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

    • A、REBUILD
    • B、CASCADE
    • C、TRUNCATE
    • D、ROW MOVEMENT
    • E、SHRINK SPACE COMPACT
    • F、SHRINK SPACE CASCADE

    正确答案:E

  • 第4题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第5题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

    • A、 SQL Tuning Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 Segment Advisor

    正确答案:D

  • 第6题：

    单选题
    You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）
    A

     DBMS_WORKLOAD_REPOSITORY

    B

     DBMS_RESOURCE_MANAGER

    C

     DBMS_SQLTUNE

    D

     DBMS_ADVISOR


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

  • 第7题：

    单选题
    In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）
    A

     REBUILD

    B

     CASCADE

    C

     TRUNCATE

    D

     ROW MOVEMENT

    E

     SHRINK SPACE COMPACT

    F

     SHRINK SPACE CASCADE


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

  • 第8题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


    正确答案： A,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题：

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


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

  • 第11题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


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

  • 第12题：

    单选题
    You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
    A

    DBMS_SERVER_ALERT

    B

    DBMS_ADVISOR

    C

    DBMS_RESOURCE_MANAGER

    D

    DBMS_REPAIR


    正确答案： 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题：

    Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

    • A、Access path analysis is not performed for the SQL statements.
    • B、SQL structure analysis is not performed for the SQL statements.
    • C、SQL Profile recommendations are not generated for the SQL statements.
    • D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

    正确答案:C

  • 第15题：

    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.

    正确答案:B,C,D

  • 第16题：

    You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

    • A、 DBMS_WORKLOAD_REPOSITORY
    • B、 DBMS_RESOURCE_MANAGER
    • C、 DBMS_SQLTUNE
    • D、 DBMS_ADVISOR

    正确答案:C

  • 第17题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


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

  • 第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题：

    多选题
    Which are the three levels at which the Segment Advisor generates advice?（）
    A

    block level

    B

    object level

    C

    schema level

    D

    segment level

    E

    tablespace level


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

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


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

  • 第24题：

    单选题
    In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）
    A

    REBUILD

    B

    CASCADE

    C

    TRUNCATE

    D

    ROW MOVEMENT

    E

    SHRINK SPACE COMPACT

    F

    SHRINK SPACE CASCADE


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

相关内容