Which script must you query in Oracle to display the code associated with RMAN stored scripts?

Correct option is A

In Oracle, the RC_STORED_SCRIPT_LINE script is queried to display the code associated with RMAN (Recovery Manager) stored scripts. This view contains the script code broken into individual lines for each stored script.
Important Key Points:
1. RC_STORED_SCRIPT_LINE: This view stores the script code in line-by-line format.
2. RMAN Stored Scripts: Scripts in RMAN are reusable sequences of RMAN commands stored in the recovery catalog.
3. Usage: Enables querying specific details of stored scripts, such as retrieving, modifying, or validating script code.
4. RC_STORED_SCRIPT: Contains metadata about stored scripts, but not the script's code.
Knowledge Booster:
· Stored Scripts Purpose: These are often used for automating recurring backup and recovery tasks in Oracle databases.
· Query Syntax Example: SELECT * FROM RC_STORED_SCRIPT_LINE WHERE SCRIPT_NAME = '<SCRIPT_NAME>';