Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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.
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

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.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Full explanation
Multiple choice technology databases

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

  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
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation