⟩ What are the PL/SQL Statements used in cursor processing?
DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.
DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.
Explain when do you recommend hot backup? What are the pre-reqs?
How to identify the expired, active, obsolete backups? Which RMAN command you use?
How to install the RMAN recovery catalog?
How to see information about backups in RMAN?
What are the various tape backup solutions available in the market?
Explain the steps for recovering the full database from cold backup?
Tell me atleast 6 advantages of RMAN backups compare to traditional hot backups?
How to enable the autobackup for the controlfile using RMAN?
What is the difference between cumulative incremental and differential incremental backups?
What is hot backup and what is cold backup?