databases Online Quiz - 179
Description: databases Online Quiz - 179 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?
Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?
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?
Which data dictionary view contains information explaining why ADDM made its recommendations?
Which of the following advisors determines if the space allocated to the Shared Pool, Large Pool, or Buffer Cache are adequate?
Which of the following advisors determines if the estimated instance recovery duration is within the expected service-level agreements?
Using EM Database Control, you’ve identified that the following SQL statement is the source of a high amount of disk I/O: SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS What might you do first to try to improve performance?
Your users have called to complain that system performance has suddenly decreased markedly. Where would be the most likely place to look for the cause of the problem in the EM Database Control?
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?
Which of the following is a performance metric that could be defined as “the amount of work that a system can perform in a given amount of time”?
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?
Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?
When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?
If no e-mail address is specified, where will alert information be displayed?
If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;
NULLIF(12, 13) would return 12 ?
SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders? this query is:
This query is: INSERT ALL INTO mytab (c1,c2) VALUES ('ram',12) INTO mytab (c1,c2) VALUES ('mani',15)