⟩ Explain the usage of WHERE CURRENT OF clause in cursors?
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
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?
What is the difference between physical and logical backups?
Tell me is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?
Explain the steps for changing the DBID in a cloned environment?
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?