databases Online Quiz - 179
|Description: databases Online Quiz - 179|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?
Nearly all the advisors submit their analysis activities to the database in the form of a job. When the analysis job is submitted, which option for job scope adds the least overhead to the system?
By default, how long will database statistics be retained in the AWR?
Which of the following is not one of the three primary sources of performance metric information in the EM Database Control Performance screen?
Using EM Database Control, you discover that two application PL/SQL functions and a view are currently invalid. Which of the following might you use to fix these objects?
NULLIF(12, 13) would return 12 ?