Triggers can only be used to update table values PLSQL block
Triggers can only be used to update table values. PL/SQL blocks have a section used to declare variables. True False
Solution
Please find the answers below:
1) False; triggers are not only used to update the table values, but also they are being used in many places like: generating derived column, enforcing referential integrity, imposing security authorizations, etc...
2) True; PL/SQL has a dedicated section where the variables are being declared. The blocks name is DECLARE block, which comes before the actual code of statements which is defined in a BEGIN - END blocks.
