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

题目内容(请给出正确答案)

单选题

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?（）

Segment Advisor

SQL Tuning Advisor

SQL Access Advisor

Segment Resource Estimation

Automatic Database Diagnostic Monitor (ADDM)

参考答案和解析

正确答案： C

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题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？（）ASQL Tuning AdvisorBSQL Access AdvisorCUndo AdvisorDSegment Advisor

点击查看答案
第2题

多选题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 managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.

点击查看答案
第3题

单选题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 DBNEWID utilityB the ANALYZE commandC the RMAN LIST commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the RMAN BLOCKRECOVER command

点击查看答案
第4题

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

点击查看答案
第5题

单选题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 add data files to the tablespace B identify the segments that you should shrink C modify the storage parameters for the tablespace D automatically shrink the segments with unused space E check the alerts generated for the tablespace that is running low on space

点击查看答案
第6题

单选题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_ALERTB DBMS_ADVISORC DBMS_RESOURCE_MANAGERD DBMS_REPAIR

点击查看答案
第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 REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE

点击查看答案

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

第2题

第3题

第4题

第5题

第6题

第7题

相关内容