Set - 7

Question 66 :

What are the different modes of mounting a Database with the Parallel Server ?

Answer :

Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.
Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.


Question 67 :

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Answer :

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.


Question 68 :

What are the steps involved in Database Shutdown ?

Answer :

Close the Database, Dismount the Database and Shutdown the Instance.


Question 69 :

What is Archived Redo Log ?

Answer :

Archived Redo Log consists of Redo Log files that have archived before being reused.


Question 70 :

What is Restricted Mode of Instance Startup ?

Answer :

An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.