Category «1Z0-045»

which segments to shrink?

You have 100 segments in the USERS tablespace. You get an alert that the USERStablespace is running low on space. You decide to shrink some segments. Which optionwould you use to determine which segments to shrink? A.SQL Access Advisor B.Automatic Database Diagnostic Monitor (ADDM) C.Segment Resource Estimation D.Segment Advisor E.SQL Tuning Advisor Show Answer

Which task would be accomplished by the command?

Consider the following configuration:/devices/D1 is a member of disk group dgroupA ./devices/D2 is a member of disk group dgroupA ./devices/D3 is a member of disk group dgroupA .You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute thefollowing command:SQL> ALTER DISKGROUP dgroupA ADD DISK ‘/devices/D*’;Which task would be accomplished by …

What is the Character Set Scanner?

What is the Character Set Scanner? A.a separate program that searches the database for invalid strings B.a package (DBMS_CSS) that searches the database for invalid strings C.a separate program that searches for strings that require Unicode conversion if you want to support multiple languages D.a separate program that identifies character data loss if you change …

What must you do to enable Automated SQL Execution Memory Management?

What must you do to enable Automated SQL Execution Memory Management? A.Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE. B.Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE all to AUTO. C.Set the instance parameter PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to appropriate values. D.Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values Show Answer