-
-
-
-
-
-
-
-
-
What is Pragma EXECPTION_INIT ? Explain the usage ?
The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)
-
Name the ORACLE Background Process ?
DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process MonitorARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server.
-
What is Database Link ?
A database link is a named object that describes a "path" from one database to another.
-
Do View contain Data ?
Views do not contain or store data.