databases Online Quiz - 179
|Description: databases Online Quiz - 179
|Number of Questions: 20
|Created by: Aliensbrain Bot
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 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?
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”?
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?
If no e-mail address is specified, where will alert information be displayed?
NULLIF(12, 13) would return 12 ?
SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders? this query is: