多选题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.
多选题
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.
参考解析
解析:
暂无解析
相关考题:
You need to write a code segment that transfers the contents of a byte array named dataToSendby using a NetworkStream object named netStream.You need to use a cache of size 8,192 bytes.Which code segment should you use?()A.B.C.D.
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
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.
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?()A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.
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 tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
What is the first step that you would use Cisco Product Advisor for when selecting a router for an Edge solution?() A. determine types of protocols to be supportedB. determine the environment in which the router will be usedC. select the number of WAN ports requiredD. select the number of LAN ports required
What is the first step that you would use Cisco Product Advisor for when selecting a router for an Edge solution?()A、 determine types of protocols to be supportedB、 determine the environment in which the router will be usedC、 select the number of WAN ports requiredD、 select the number of LAN ports required
If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?()A、 TS_OBJECTS_TO_BE_DROPPEDB、 TS_PTTR_OBJECT_DROPPEDC、 TS_PITR_OBJECTS_TO_BE_DROPPEDD、 TS_OBJECTS_DROPPEDE、 TS_DROPPED_OBJECTS
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 AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
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 AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
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 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 AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 Segment Advisor
单选题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().Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck the alerts generated for the tablespace that is running low on space
单选题You create a method that runs by using the credentials of the end user. You need to use Microsoft Windows groups to authorize the user. You must add a code segment that identifies whether a user is in the local group named Clerk.Which code segment should you use?()A AB BC CD D
单选题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?()ASegment Advisor BSQL Tuning Advisor CSQL Access Advisor DSegment Resource Estimation EAutomatic Database Diagnostic Monitor (ADDM)
多选题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.
单选题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
单选题If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?()A TS_OBJECTS_TO_BE_DROPPEDB TS_PTTR_OBJECT_DROPPEDC TS_PITR_OBJECTS_TO_BE_DROPPEDD TS_OBJECTS_DROPPEDE TS_DROPPED_OBJECTS
单选题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?()ADBMS_SERVER_ALERTBDBMS_ADVISORCDBMS_RESOURCE_MANAGERDDBMS_REPAIR
单选题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 AdvisorB SQL Access AdvisorC Undo AdvisorD Segment Advisor
单选题What is the first step that you would use Cisco Product Advisor for when selecting a router for an Edge solution?()A determine types of protocols to be supportedB determine the environment in which the router will be usedC select the number of WAN ports requiredD select the number of LAN ports required
单选题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 AdvisorB Undo AdvisorC ADDMD Memory Advisor
单选题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()。Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
单选题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
单选题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 AdvisorB Segment AdvisorC Undo AdvisorD SQL Tuning Advisor
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A You must enable the row movement on the SCOTT.EMP table.B You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
单选题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?()AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE
单选题You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL SELECT dbms_addm.get_report(’my_instance_analysis_mode_task’) FROM dual; You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this?()A Add a finding directive for the ADDM task.B Add a segment directive for the ADDM task.C Add a parameter directive for the ADDM task.D Disable the Segment Advisor from the Automatic Maintenance Task.