Set - 9

Question 11 :

When a user process fails, what background process cleans up after it?

Answer :

PMON


Question 12 :

What background process refreshes materialized views?

Answer :

The Job Queue Processes.


Question 13 :

How would you determine what sessions are connected and what resources they are waiting for?

Answer :

Use of V$SESSION and V$SESSION_WAIT


Question 14 :

Describe what redo logs are.

Answer :

Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.


Question 15 :

How would you force a log switch?

Answer :

ALTER SYSTEM SWITCH LOGFILE;