Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Segment Resource Estimation
Automatic Database Diagnostic Monitor (ADDM)
第1题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第2题:
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?()
第3题:
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?()
第4题:
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?()
第5题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第6题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第7题:
DBMS_STATS
DBMS_ALERT
DBMS_SPACE
DBMS_MONITOR
DBMS_SERVER_ALERT
DBMS_SPACE_ADMIN
第8题:
ADDM
Memory Advisor
Segment Advisor
Undo Management
SQL Tuning Advisor
SQL Access Advisor
第9题:
Add a finding directive for the ADDM task.
Add a segment directive for the ADDM task.
Add a parameter directive for the ADDM task.
Disable the Segment Advisor from the Automatic Maintenance Task.
第10题:
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
It may advise the use of online table redefinition for tables in locally managed tablespaces
It will detect and advise about chained rows.
It may advise the use of segment shrink for free list managed tables.
第11题:
The EMPLOYEES table will be changed to read-only mode during the shrink operation.
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
第12题:
DBMS_SERVER_ALERT
DBMS_ADVISOR
DBMS_RESOURCE_MANAGER
DBMS_REPAIR
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Segment Resource Estimation
Automatic Database Diagnostic Monitor (ADDM)
第17题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第18题:
Memory Advisor
Segment Advisor
Undo Advisor
SQL Tuning Advisor
第19题:
The data in the segment will be compacted but the high water mark will not be adjusted
The EMPLOYEES table will be changed to read-only mode during the shrink operation
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
第20题:
SQL Tuning Advisor
Undo Advisor
ADDM
Memory Advisor
第21题:
SQL Tuning Advisor
SQL Access Advisor
Undo Advisor
Segment Advisor
第22题:
the DBNEWID utility
the ANALYZE command
the RMAN LIST command
the RMAN REPORT command
the RMAN CROSSCHECK command
the RMAN BLOCKRECOVER command
第23题:
add data files to the tablespace
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第24题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE