1z0-043章節(jié)練習(2019.03.21)

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. 
Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）

You receive the following error：  
ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit  
Identify the reason for receiving the above error message？（）

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%. 
To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：       
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP 
（’SCOTT’，       ’GRP1’， FALSE）；  
How will you grant the switch privilege to the user， Scott？（）  

You lost the index tablespace in your database. You decided to re­create the index tablespace and the indexes in the tablespace. 
What methods can you use to re­create the indexes？（）