⟩ Write the order of precedence for validation of a column in a table? I. done using Database triggers. ii. done using Integarity Constraints
I & ii.
Exception :
I & ii.
Exception :
How RMAN improves backup time?
What is the difference between obsolete RMAN backups and expired RMAN backups?
Explain the steps for recovery with missing online redo logs?
How would you speed up the RMAN backup of a 500GB database?
Tell me what is the meaning of configure encryption algorithm in rman and why we need to set this parameter in rman configuration?
Explain what is the significance of incarnation and DBID in the RMAN backups?
Tell me the steps involved in CANCEL based recovery from the full database from hot backup?
Explain where RMAN keeps information of backups if you are using RMAN without Catalog?
How to identify what are the all the target databases that are being backed-up with RMAN database?
Explain when do you recommend hot backup? What are the pre-reqs?