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

Read More

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 […]

Read More

Which two statements regarding a SQL profile are true?

Which two statements regarding a SQL profile are true? (Choose two.) A.It is built by Automatic Tuning Optimizer. B.It can be used by the query optimizer automatically. C.It can be created manually by using the CREATE PROFILE command. D.It cannot be stored persistently in the data dictionary. Explanation: Show Answer

Read More

Which two statements regarding unusable indexes are correct?

Which two statements regarding unusable indexes are correct? (Choose two.) A.Your Data Definition Language (DDL) statement shows a warning message when an index is made unusable. B.You do not need to set any parameter because unusable indexes are skipped automatically. C.You can check the alert log file to get a message recorded about unusable indexes. […]

Read More

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 […]

Read More

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

Read More