⟩ What are the datatypes a available in PL/SQL?
Some scalar data types such as
NUMBER,
VARCHAR2,
DATE,
CHAR,
LONG,
BOOLEAN.
Some composite data types such as RECORD & TABLE.
Some scalar data types such as
NUMBER,
VARCHAR2,
DATE,
CHAR,
LONG,
BOOLEAN.
Some composite data types such as RECORD & TABLE.
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
Tell us In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?
List some of the RMAN catalog view names which contains the catalog information?
Explain the steps involved in TIME based recovery from the full database from hot backup?
Explain the encryption options available with RMAN?
What are things which play major role in designing the backup strategy?
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
How to identify the block corruption in RMAN database? How do you fix it?
Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?
Explain the steps involved in SCN based recovery from the full database from hot backup?