Cursor variables are easier to use than cursors because:
► Cursor variables are easier to define. No need to give a specific query statement.
► Cursor variables are easier to open. You can specify the query dynamically at the time of open.
► Cursor variables can be passed into procedures or functions.
What are the steps involved in Instance Recovery in Oracle?
Do you need a commit after DDL statements?
How would you pass hints to the SQL processor?
what is the difference between group by and order by?
A DBA had to remove some Archivelogs to free up space in filesystem. Now when the RMAN job starts to backup Archivelogs, it complains about missing Archivelogs that were deleted by DBA. To resolve the issue and continue backing up remainder of Archivelogs, which RMAN command can be used so it wo not complain about missing Archivelogs.
Which RMAN command is used to create an exact replica of a database in new host?
How do you install Statspack?
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in order to improve the performance?)
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?
List five most important parameter in 9i affecting performance?
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
