Which of the following is managed in a manner that free blocks are always made available for new blocks being read into memory?

Which of the following is in turn made up the persistent area that contains bind information and a run time area that is created as soon as an execute request is initiated?

Which of the following files facilitates the Oracle mechanism to recover from an instance failure or a media failure?

The database application issuing the distributed transaction is directly connected to the node acting as the which of the following?

Which of the following prevents SQL statements from being repeatedly parsed thus improving performance during execution of SQL statements?

In which of the following phases does RMAN determine the objects accessed by a command?

Two specific caches library cache and the data dictionary cache form which of the following pools?

Which of the following files is very useful in the event of a failure and is used for recovery purposes?

Which of the following has the main functions to provide session memory for the shared server environment and parallel execution message buffers?

Which of the following file stores the name of the database, the names and locations of the tablespaces in the database, the location of the redo files etc.?

Which of the following files allows you to to specify the values to attributes that can be enforced without bouncing the database as well as after re-starting the database?

Which of the following stores the most critical data which never remains in-doubt, even if a failure occurs?

The contents of which of the following are essential for instance recovery purposes?

In which of the following modes does the transaction require only to read the data item?

Which of the following will frequently group together similar objects such as relations for a specific business area or a specific function?