1. UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation attributes and their data types must be different.
2. SQL supports the conditional execution of procedures (if...then...else statements) that are typically sup-ported by a programming language
3. To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.
4. Procedural code is executed on the database client machine.
5. PL/SQL functions are executed in the same way as functions such as MIN and AVG.
6. Every PL/SQL block must be given a name
7. In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
8. PL/SQL blocks have a section used to declare variables.
9. The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.
10. Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.
11. A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
12. A trigger is executed as part of the transaction that triggered it.
13. Triggers can only be used to update table values
14. A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
15. Each statement inside the PL/SQL code must end with a period (“.”).
16. To test a trigger, you should use the EXECUTE TRIGGER command.
17. Just like database triggers, stored procedures are stored in the database.
18. One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
19. One of the disadvantages of stored procedures is that they increase network traffic
20. Stored procedures help reduce code duplication by means of code isolation and code sharing
21. Stored procedures must have at least one argument.
22. You can declare variables inside a stored procedure.
23. Stored procedures are executed using the EXEC command.
24. Cursors are held in a reserved memory area in the client computer.
25. An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
26. An explicit cursor must return two or more rows
27. The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.
28. Cursor-style processing involves retrieving data from the cursor, one row at a time.
29. A stored function is another name for a stored procedure
30. "Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.
