(Continued from previous part...)

133. Talk about “Exception Handling” in PL/SQL?

2 types of Exception In User-defined & Pre-defined.Any Error can be Handled by Pre-defined Exception Handler (Ex. no_data_found,too_many_rows etc.)
In User-defined exception has to declare in Declaration section and any exception can be handled by that Exception name. Any types of Exception(User-defined & Pre-defined) can be Handled by When Others exception Handler.

134. Give some examples of Analytical functions

rank,dense_rank,rollup,cube etc

135. What is Log Switch?

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.

136. What is On-line Redo Log?

The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.

137. Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

138. What are the steps involved in Database Startup?

Start an instance, Mount the Database and Open the Database.

139. What are the steps involved in Instance Recovery?

Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process at the time of the failure.
Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.

140. Can Full Backup be performed when the database is open?

No.

141. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

(Continued on next part...)