⟩ Explain how procedures and functions are called in a PL/SQL block?
Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');
Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');
Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?
How to verify the integrity of the image copy in RMAN environment?
Tell me can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
What are RTO, MTBF, and MTTR?
What is the advantage of RMAN utility?
What is backup set in RMAN?
Explain the steps for recovery of missing data file?
Explain the steps required to enable the RMAN backup for a target database?
How to generate the begin backup script?
What is auxiliary channel in RMAN? When do you need this?