0

databases Online Quiz - 179

Description: databases Online Quiz - 179
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. OFF

  2. TYPICAL

  3. ALL

  4. BASIC


Correct Option: D

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?

  1. Limited

  2. Restricted

  3. Comprehensive

  4. Thorough


Correct Option: A
  1. DBA_ADVISOR_FINDINGS

  2. DBA_ADVISOR_OBJECTS

  3. DBA_ADVISOR_RECOMMENDATIONS

  4. DBA_ADVISOR_RATIONALE


Correct Option: D
  1. Run the SQL Tuning Advisor.

  2. Run the SQL Access Advisor.

  3. Check the EM Database Control main screen for alerts.

  4. Click the Alert Log Content link in the EM Database Control main screen.


Correct Option: A

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

  1. 7 days

  2. 30 days

  3. 7 hours

  4. Indefinitely


Correct Option: A

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

  1. Host

  2. Session

  3. Instance

  4. Network


Correct Option: D

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?

  1. The PFILE/SPFILE parameter GATHER_STATS=FALSE.

  2. Only databases created using Database Configuration Assistant have automatic statistics

  3. The SYSMAN user who owns the AWR is not logged in.

  4. The operating system does not support automatic statistics collection.


Correct Option: B

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?

  1. Shut down and restart the database.

  2. Use EM Database Control to recompile the object.

  3. Export the invalid objects, drop them, and then import them.

  4. Use the ALTER FUNCTION … COMPILE and ALTER VIEW … COMPILE commands.


Correct Option: B,D
  1. You might want a separate baseline metric for each user.

  2. You might want a separate baseline metric for daytime usage versus off-hours usage.

  3. You might want a separate baseline metric for each schema.

  4. You would never want more than one baseline metric, even though it is possible to gather


Correct Option: B

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

  1. Warning threshold

  2. Critical threshold

  3. Both A and B

  4. Neither A or B


Correct Option: C
  1. In the DBA_ALERTS data dictionary view

  2. In the V$ALERTS dynamic performance view

  3. In the EM Database Control main screen

  4. No alert information is sent or displayed.


Correct Option: C

NULLIF(12, 13) would return 12 ?

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A
- Hide questions