RELATIONAL DATABASE MANAGEMENT SYSTEM
QUESTION BANK
UNIT 1
1. What is PL/SQL?
2. What are the key advantages of PL/SQL?
3. What are the components of a generic PL/SQL block?
4. What is the Declare section in a PL/SQL block?
5. What is the purpose of the Begin section?
6. How does the Exception section function in PL/SQL?
7. What does the End section signify in a PL/SQL block?
8. What does the PL/SQL execution environment refer to?
9. What is the character set in PL/SQL?
10. What are literals in PL/SQL?
11. What types of data can be declared in PL/SQL?
12. How do you declare a variable in PL/SQL?
13. What are constants in PL/SQL?
14. What are LOB types in PL/SQL?
15. How are logical comparisons performed in PL/SQL?
16. How do you display messages on the VDU screen in PL/SQL?
17. How can you add comments in PL/SQL?
18. List What are control structures in PL/SQL?
19. How does conditional control work in PL/SQL?
20. What is iterative control in PL/SQL?
21. What is sequential control in PL/SQL?
UNIT 2
22. What is a transaction in Oracle?
23. How do you close a transaction in Oracle?
24. What is a SAVEPOINT in Oracle?
25. What is a cursor in Oracle?
26. What are the types of cursors in Oracle?
27. What is an implicit cursor?
28. How does implicit cursor processing work in a client-server environment?
29. What are implicit cursor attributes?
30. What is an explicit cursor?
31. What are the open, fetch, and close commands for cursors
32. What are explicit cursor attributes?
33. What is a cursor FOR loop?
34. What is a parameterized cursor?
35. How do you declare a parameterized cursor?
36. How do you open a parameterized cursor and pass values?
37. What is locking in Oracle?
38. What are the types of locks in Oracle?
RELATIONAL DATABASE MANAGEMENT SYSTEM
QUESTION BANK
39. What are the levels of locks in Oracle?
40. What is explicit locking in Oracle?
41. What is the SELECT...FOR UPDATE statement?
42. How we can lock the table, write syntax.
UNIT 3
43. What is a stored procedure?
44. What is a stored function?
45. What is the declarative section of a procedure or function?
46. What is the executable section of a procedure or function?
47. What is the use of exception handling section?
48. Where are stored procedures and functions stored in Oracle?
49. How does the Oracle engine create a stored procedure/function with syntax?
50. How does the Oracle engine execute stored procedures/functions with syntax?
51. What are the advantages of using stored procedures/functions?
52. What are the differences between procedures and functions?
53. What keywords and parameters are used to create functions?
54. How do you use a stored function?
55. How do you delete a stored procedure or function with syntax?
56. What is Exception in PL/SQL?
57. What is Oracle’s named exception handlers?
58. What is exception handlers in PL/SQL?
59. What is user-defined exception handling?
60. Write syntax for user define exception handling.
61. What is use of Pragma_exception init()?
UNIT 4
62. What is a package in Oracle?
63. What are the components of an Oracle package?
64. Why use a package?
65. How to create packages with syntax?
66. How do you invoke a package in Oracle with syntax?
67. What is the syntax for Dot Notation?
68. What are package objects—Private vs. Public?
69. What is package state?
70. What is package dependency?
71. What is the difference between database triggers and procedures?
72. What is the difference between database triggers and declarative integrity
constraints?
73. What are row triggers?
74. What are statement triggers?
75. What is the difference between before and after triggers?
RELATIONAL DATABASE MANAGEMENT SYSTEM
QUESTION BANK
