Set - 9

Question 96 :

What are the two parts of a procedure ?

Answer :

Procedure Specification and Procedure Body.


Question 97 :

What is the basic structure of PL/SQL ?

Answer :

PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL


Question 98 :

What is PL/SQL table ?

Answer :

Objects of type TABLE are called "PL/SQL tables", which are modeled as (but not the same as) database tables, PL/SQL tables use a primary PL/SQL tables can have one column and a primary key. Cursors


Question 99 :

WHAT IS RMAN ? (for DBA)

Answer :

Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.


Question 100 :

WHY USE RMAN ? (for DBA)

Answer :

No extra costs …Its available free
?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups
?Proper security
?You are 100% sure your database has been backed up.
?Its contains detail of the backups taken etc in its central repository
Facility for testing validity of backups also commands like crosscheck to check the status of backup.
Faster backups and restores compared to backups without RMAN
RMAN is the only backup tool which supports incremental backups.
Oracle 10g has got further optimized incremental backup which has resulted in improvement of performance during backup and recovery time
Parallel operations are supported
Better querying facility for knowing different details of backup
No extra redo generated when backup is taken..compared to online
backup without RMAN which results in saving of space in hard disk
RMAN an intelligent tool
Maintains repository of backup metadata
Remembers backup set location
Knows what need to backed up
Knows what is required for recovery
Knows what backups are redundant