.Mastering Subprograms &
Triggers in PL/SQL (MIT412)
- Updated 2025/2026 Study
Notes for First-Attempt Pass
What does PL/SQL stand for?
Procedural Language/Structured Query Language
,What is the primary purpose of PL/SQL?
It is an extension to SQL designed for the Oracle Database.
How does SQL differ from PL/SQL?
SQL is declarative, while PL/SQL is imperative.
What is a key characteristic of PL/SQL?
It combines program logic and control flow with SQL.
What are the three main sections of a PL/SQL block?
Declaration Section, Executable Section, Exception-handling Section.
What is the purpose of the DECLARE keyword in PL/SQL?
It begins the Declaration Section where variables and constants are defined.
What does the BEGIN keyword signify in a PL/SQL block?
It marks the start of the Executable Section.
, What is the role of the EXCEPTION section in PL/SQL?
It specifies actions to take when errors occur in the Executable Section.
What is an anonymous block in PL/SQL?
A block without a name that is not stored in the database and runs once.
What are named blocks in PL/SQL?
Stored objects like Procedures, Functions, Packages, and Triggers.
What is one benefit of using PL/SQL?
Integration of Procedural Constructs with SQL.
How does PL/SQL improve performance?
It allows combining multiple SQL statements into one block, reducing database calls.
What is the significance of modularized program development in PL/SQL?
It allows grouping logically related statements within blocks for easier maintenance.
What is the purpose of exception handling in PL/SQL?
Triggers in PL/SQL (MIT412)
- Updated 2025/2026 Study
Notes for First-Attempt Pass
What does PL/SQL stand for?
Procedural Language/Structured Query Language
,What is the primary purpose of PL/SQL?
It is an extension to SQL designed for the Oracle Database.
How does SQL differ from PL/SQL?
SQL is declarative, while PL/SQL is imperative.
What is a key characteristic of PL/SQL?
It combines program logic and control flow with SQL.
What are the three main sections of a PL/SQL block?
Declaration Section, Executable Section, Exception-handling Section.
What is the purpose of the DECLARE keyword in PL/SQL?
It begins the Declaration Section where variables and constants are defined.
What does the BEGIN keyword signify in a PL/SQL block?
It marks the start of the Executable Section.
, What is the role of the EXCEPTION section in PL/SQL?
It specifies actions to take when errors occur in the Executable Section.
What is an anonymous block in PL/SQL?
A block without a name that is not stored in the database and runs once.
What are named blocks in PL/SQL?
Stored objects like Procedures, Functions, Packages, and Triggers.
What is one benefit of using PL/SQL?
Integration of Procedural Constructs with SQL.
How does PL/SQL improve performance?
It allows combining multiple SQL statements into one block, reducing database calls.
What is the significance of modularized program development in PL/SQL?
It allows grouping logically related statements within blocks for easier maintenance.
What is the purpose of exception handling in PL/SQL?
