PL/SQL Question Bank

1. What is PL/SQL?
2. How is PL/SQL different from SQL?
3. What are the advantages of using PL/SQL?
4. What is a PL/SQL block?
5. What are the types of PL/SQL blocks?
6. What is the structure of an anonymous block?
7. How do you print output in PL/SQL?
8. What are variables in PL/SQL?
9. How do you declare and initialize variables?
10. What are scalar data types in PL/SQL?
11. What are bind variables?
12. How do you assign values to variables?
13. What are literals in PL/SQL?
14. What is %TYPE and how is it used?
15. What is %ROWTYPE and when do you use it?
16. What is a constant in PL/SQL?
17. What are comments in PL/SQL?
18. What is the scope of a variable in PL/SQL?
19. What are the different sections in a PL/SQL block?
20. Can we nest PL/SQL blocks?

21. What are control structures in PL/SQL?

22. How is the IF statement used in PL/SQL?
23. What is the syntax for IF-THEN-ELSE?
24. What is a CASE statement?
25. How do you use loops in PL/SQL?
26. What is the difference between FOR, WHILE, and LOOP?
27. How do you exit a loop in PL/SQL?
28. What is the CONTINUE statement?
29. What is the EXIT WHEN clause?
30. How do you use nested loops?
31. What is the difference between EXIT and GOTO?
32. What is a NULL statement in PL/SQL?
33. How do you write a WHILE loop in PL/SQL?
34. What is the difference between simple and labeled loops?
35. How do you avoid infinite loops in PL/SQL?
36. What is short-circuit evaluation in PL/SQL?
37. Can you use logical operators in IF conditions?
38. What is a cursor FOR loop?
39. What is loop labeling?
40. What are practical use cases of loops in PL/SQL?

41. What is a cursor?

42. What are the types of cursors in PL/SQL?
43. What is an implicit cursor?
44. What is an explicit cursor?
45. What are cursor attributes?
46. What is %FOUND and %NOTFOUND?
47. How do you declare an explicit cursor?
48. How do you open and fetch from a cursor?
49. How do you close a cursor?
50. What are the benefits of using cursors?
51. What is a cursor FOR loop?
52. What is a parameterized cursor?
53. What are the limitations of cursors?
54. What are cursor exceptions?
55. How do you check if a cursor is open?
56. Can cursors be nested?
57. What is a REF CURSOR?
58. What is a weak REF CURSOR?
59. What is a strong REF CURSOR?
60. What is the difference between explicit and implicit cursors?

61. What are exceptions in PL/SQL?

62. What is the structure of exception handling?
63. What are predefined exceptions?
64. What is NO_DATA_FOUND exception?
65. What is TOO_MANY_ROWS exception?
66. What is OTHERS in exception handling?
67. How do you raise a user-defined exception?
68. What is the RAISE statement?
69. What is the RAISE_APPLICATION_ERROR() procedure?
70. How do you log exceptions in a table?

71. What is a stored procedure?

72. How do you create a procedure in PL/SQL?
73. What are IN, OUT, and IN OUT parameters?
74. How do you call a procedure?
75. What is a stored function?
76. What is the difference between a function and a procedure?
77. How do you return a value from a function?
78. What are advantages of stored procedures?
79. How do you modify a procedure?
80. How do you drop a procedure?
81. What is overloading in PL/SQL?
82. Can you overload a procedure?
83. What is a forward declaration?
84. How do you handle errors in procedures?
85. What is AUTHID CURRENT_USER?
86. What are deterministic functions?
87. How do you execute a function in SELECT?
88. Can you use DML inside functions?
89. What is the difference between standalone and packaged procedures?
90. How do you debug a PL/SQL procedure?

91. What is a package in PL/SQL?

92. What are the components of a package?
93. How do you create a package specification?
94. How do you create a package body?
95. What is the use of a package?
96. What are private and public elements in a package?
97. What are initialization sections in a package?
98. How do you call a procedure from a package?
99. What is the advantage of packages over standalone procedures?
100. What is stateful behavior in packages?
101. How do you hide implementation details using packages?
102. What happens when you change a package body?
103. What is package overloading?
104. What is the difference between package and schema?
105. How do you drop a package?
106. What are forward declarations in packages?
107. How do you compile packages?
108. What is dependency tracking in PL/SQL?
109. What is package initialization block?
110. How to see package content from SQL Developer?

111. What is a trigger?

112. What are the types of triggers?
113. How do you create a trigger?
114. What is a BEFORE trigger?
115. What is an AFTER trigger?
116. What is a row-level trigger?
117. What is a statement-level trigger?
118. What is a compound trigger?
119. How do you disable a trigger?
120. How do you enable a trigger?
121. What is OLD and NEW in triggers?
122. What is the mutating table error?
123. How do you avoid mutating table errors?
124. What is a DDL trigger?
125. What is a database-level trigger?
126. How do you drop a trigger?
127. How do you audit changes using triggers?
128. Can triggers call procedures?
129. What are autonomous triggers?
130. How to test a trigger?

131. What are collections in PL/SQL?

132. What is a VARRAY?
133. What is a nested table?
134. What is an associative array (index-by table)?
135. How do you initialize a collection?
136. What are collection methods (COUNT, EXTEND, etc.)?
137. How do you loop through a collection?
138. What is the use of BULK COLLECT?
139. What is the use of FORALL?
140. What are records in PL/SQL?
141. What is the difference between a record and a collection?
142. How do you declare a record using %ROWTYPE?
143. How do you use nested collections?
144. What are limitations of collections?
145. Can you use collections in procedures?
146. How do you update a collection?
147. What is table of records?
148. How to sort collections?
149. What is a cursor-based collection?
150. What are PL/SQL tables?

151. What is bulk processing in PL/SQL?

152. What is BULK COLLECT and how does it improve performance?
153. What is the use of LIMIT clause in bulk operations?
154. What is the difference between BULK COLLECT and FOR LOOP?
155. What is the FORALL operator?
156. What are the advantages of FORALL?
157. How can you measure performance of PL/SQL code?
158. What is native compilation in PL/SQL?
159. What is DBMS_PROFILER?
160. What is PL/Scope?
161. How do you reduce context switching between SQL and PL/SQL?
162. What is pipelined table function?
163. What is a pragma in PL/SQL?
164. What is PRAGMA AUTONOMOUS_TRANSACTION?
165. What is PRAGMA EXCEPTION_INIT?
166. What is NOCOPY hint in parameters?
167. What is PL/SQL compiler optimization level?
168. How to optimize loops in PL/SQL?
169. What is DBMS_SQL?
170. What are dynamic SQL and its types?

171. What is dynamic SQL?

172. What is EXECUTE IMMEDIATE?
173. What is DBMS_SQL package?
174. How is DBMS_SQL different from EXECUTE IMMEDIATE?
175. What is SQL Injection in PL/SQL?
176. How do you avoid SQL Injection in dynamic SQL?
177. What is DBMS_OUTPUT?
178. What is UTL_FILE package?
179. How do you read/write files in PL/SQL?
180. What is DBMS_JOB?
181. What is DBMS_SCHEDULER?
182. How do you send emails from PL/SQL?
183. What is DBMS_ALERT?
184. What is DBMS_PIPE?
185. What is UTL_HTTP?
186. What is UTL_MAIL?
187. How do you run OS commands from PL/SQL?
188. What is DBMS_METADATA?
189. How to use DBMS_LOB?
190. What is DBMS_LOCK?

191. How do you debug PL/SQL code?

192. What is PL/SQL error logging?
193. How to trace PL/SQL execution?
194. What are best practices in PL/SQL programming?
195. How do you handle large datasets in PL/SQL?
196. What is secure coding in PL/SQL?
197. How do you deploy PL/SQL in production?
198. How do you version PL/SQL code?
199. What are real-world applications of PL/SQL?
200. How do you test PL/SQL procedures and functions?