RelationalDBDesign RelationalDBDesign


Parallel Server   «Prev  Next»
 

Oracle Parallel Server - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. Which problem can be resolved with transparent application failover?
Please select all the correct answers.
  A. A user loses session due to a failure in the connection to the database.
  B. A user loses session due to power outage in his/her office.
  C. A user loses session due to automatic timeout of long-waiting job.
  D. A user loses session due to failed select statement.

2. What is disk affinity?
Please select the best answer.
  A. The location of the database instance and the database files are all in the same disk.
  B. The database instance and the disk containing data needed for a transaction are on the same node.
  C. A disk containing data files is physically close to the disk containing the database instance.
  D. The database instance and all the data for the transaction are near the same node.

3. Which process uses disk affinity?
Please select all the correct answers.
  A. OPS Manager
  B. Net8
  C. DBMS_JOB
  D. Optimizer