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

第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 shrink
• B、modify the storage parameters for the tablespace
• C、automatically shrink the segments with unused space
• D、check the alerts generated for the tablespace that is running low on space

第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

第3题：

第4题：

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

第5题：

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

第6题：

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

第7题：

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

• A、 the RMAN LIST command
• B、 the DBNEWID utility
• C、 the RMAN REPORT command
• D、 the RMAN BLOCKRECOVER command
• E、 the RMAN CROSSCHECK command
• F、 the ANALYZE command

第8题：

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 SQL

第9题：

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.

第10题：

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

• A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
• C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.