Question 1

Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?

technology databases

OFF
TYPICAL
ALL
BASIC

Answer

Correct Option: D

Question 2

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?

technology databases

SQL Tuning Advisor
SQL Access Advisor
Both A and B
Neither A or B

Answer

Correct Option: C

Question 3

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?

technology databases

Limited
Restricted
Comprehensive
Thorough

Answer

Correct Option: A

Question 4

Which data dictionary view contains information explaining why ADDM made its recommendations?

technology databases

DBA_ADVISOR_FINDINGS
DBA_ADVISOR_OBJECTS
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_RATIONALE

Answer

Correct Option: D

Question 5

Which of the following advisors determines if the space allocated to the Shared Pool, Large Pool, or Buffer Cache are adequate?

technology databases

SQL Tuning Advisor
SGA Tuning Advisor
Memory Advisor
Pool Advisor

Answer

Correct Option: C

Question 6

Which of the following advisors determines if the estimated instance recovery duration is within the expected service-level agreements?

technology databases

Undo Management Advisor
SQL Access Advisor
SQL Tuning Advisor
MTTR Advisor

Answer

Correct Option: D

Question 7

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?

technology databases

Run the SQL Tuning Advisor.
Run the SQL Access Advisor.
Check the EM Database Control main screen for alerts.
Click the Alert Log Content link in the EM Database Control main screen.

Answer

Correct Option: A

Question 8

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?

technology databases

Main screen
Performance screen
Administration screen
Maintenance screen

Answer

Correct Option: B

Question 9

By default, how long will database statistics be retained in the AWR?

technology databases

7 days
30 days
7 hours
Indefinitely

Answer

Correct Option: A

Question 10

Which of the following is not one of the three primary sources of performance metric information in the EM Database Control Performance screen?

technology databases

Host
Session
Instance
Network

Answer

Correct Option: D

Question 11

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”?

technology databases

Response time
Uptime
Throughput
Runtime

Answer

Correct Option: C

Question 12

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?

technology databases

The PFILE/SPFILE parameter GATHER_STATS=FALSE.
Only databases created using Database Configuration Assistant have automatic statistics
The SYSMAN user who owns the AWR is not logged in.
The operating system does not support automatic statistics collection.

Answer

Correct Option: B

Question 13

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?

technology databases

Shut down and restart the database.
Use EM Database Control to recompile the object.
Export the invalid objects, drop them, and then import them.
Use the ALTER FUNCTION … COMPILE and ALTER VIEW … COMPILE commands.

Answer

Correct Option: B,D

Question 14

Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?

technology databases

You might want a separate baseline metric for each user.
You might want a separate baseline metric for daytime usage versus off-hours usage.
You might want a separate baseline metric for each schema.
You would never want more than one baseline metric, even though it is possible to gather

Answer

Correct Option: B

Question 15

When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?

technology databases

Warning threshold
Critical threshold
Both A and B
Neither A or B

Answer

Correct Option: C

Question 16

If no e-mail address is specified, where will alert information be displayed?

technology databases

In the DBA_ALERTS data dictionary view
In the V$ALERTS dynamic performance view
In the EM Database Control main screen
No alert information is sent or displayed.

Answer

Correct Option: C

Question 17

If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;

technology databases

a is ture
b is fasle
b is false a is ture
a is false b is ture

Answer

Correct Option: D

Question 18

NULLIF(12, 13) would return 12 ?

technology databases

True
False

Answer

Correct Option: B

Question 19

SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders? this query is:

technology databases

True
False

Answer

Correct Option: A

Question 20

This query is: INSERT ALL INTO mytab (c1,c2) VALUES ('ram',12) INTO mytab (c1,c2) VALUES ('mani',15)

technology databases

True
False

Answer

Correct Option: A

Description: databases Online Quiz - 179
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 179

Find more quizzes from top tags