The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error.
e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)
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?
How to identify the expired, active, obsolete backups? Which RMAN command you use?
How to install the RMAN recovery catalog?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
