Related InterviewSolutions

• Say True or False. If False, explain why.The %ROWCOUNT attribute returns the total number of rows returned by the FETCH command.
• Say True or False. If False, explain why.The %NOTFOUND attribute returns true when the cursor is not created explicitly.
• What is the difference between implicit and explicit cursors?
• Which command is used to delete a package?
• Say True or False. If False, explain why.PL/SQL allows subprogram overloading feature within a package.
• How do you refer to the types, objects and subprograms declared within a package?
• Which command(s) are used for creating PL/SQL packages?
• PL/SQL packages usually have two parts. What are these two parts?
• What are the steps that need to be performed to use an explicit cursor? Discuss briefly.
• What do you understand by explicit cursors?