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?
You have just created a database using scripts that you wrote. Now you notice that the automatic collection of database statistics by the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_ PROCS procedure is not running. What might be the cause?
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?
When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?
NULLIF(12, 13) would return 12 ?
This query is: INSERT ALL INTO mytab (c1,c2) VALUES ('ram',12) INTO mytab (c1,c2) VALUES ('mani',15)