Saved Bookmarks
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is the difference between implicit and explicit cursors? |
| Answer» | |
| 2. |
Which command is used to delete a package? |
| Answer» | |
| 3. |
How do you refer to the types, objects and subprograms declared within a package? |
| Answer» | |
| 4. |
Which command(s) are used for creating PL/SQL packages? |
| Answer» | |
| 5. |
PL/SQL packages usually have two parts. What are these two parts? |
| Answer» | |
| 6. |
What are the steps that need to be performed to use an explicit cursor? Discuss briefly. |
| Answer» | |
| 7. |
What do you understand by explicit cursors? |
| Answer» | |
| 8. |
How do you declare a user-defined exception? |
| Answer» | |
| 9. |
What is the difference between a function and a stored procedure? |
| Answer» | |
| 10. |
Which command is used to delete a procedure? |
| Answer» | |
| 11. |
Which command is used to delete a trigger? |
| Answer» | |
| 12. |
Write a statement to disable a trigger named update_marks. |
| Answer» | |
| 13. |
What is the purpose of the optional argument [OR REPLACE] in a CREATE TRIGGER command? |
| Answer» | |
| 14. |
What is the use of a WHEN clause in a trigger? |
| Answer» | |
| 15. |
What are the uses of triggers? |
| Answer» | |
| 16. |
What is the difference in execution of triggers and stored procedures? |
| Answer» | |
| 17. |
Which command/commands allow iteration a use of loops in a PL/SQL block? |
| Answer» | |
| 18. |
What is returned by the cursor attribute SQL%NOTFOUND? |
| Answer» | |
| 19. |
What is returned by the cursor attribute SQL%FOUND? |
| Answer» | |
| 20. |
What is returned by the cursor attribute SQL%ROWCOUNT? |
| Answer» | |
| 21. |
What are the PL/SQL cursors? |
| Answer» | |
| 22. |
What is a trigger? |
| Answer» | |
| 23. |
What is a PL/SQL package? |
| Answer» | |
| 24. |
What is the purpose of %rowtype data type? Explain with example. |
| Answer» | |
| 25. |
What is the purpose of %type data type? Explain with example. |
| Answer» | |
| 26. |
What does the colon sign (: ) implies in the following statement? |
| Answer» | |
| 27. |
Which of the following operator has the lowest precedence among the following − |
| Answer» | |
| 28. |
Which operator has the highest precedence among the following − |
| Answer» | |
| 29. |
Write a single statement that concatenates the words ‘Hello’ and ‘World’ and assign it in a variable named greeting. |
| Answer» | |
| 30. |
What is wrong in the following assignment statement? |
| Answer» | |
| 31. |
What are the three basic sections of a PL/SQL block? |
| Answer» | |
| 32. |
State some features or programming constructs supported by PL/SQL. |
| Answer» | |
| 33. |
Name few schema objects that can be created using PL/SQL? |
| Answer» | |
| 34. |
State few notable characteristics of PL/SQL. |
| Answer» | |
| 35. |
Say True or False. If False, explain why. |
| Answer» | |
| 36. |
What is the purpose of the PL/SQL language? |
| Answer» | |