Bonus Day 4
Quiz
| 1: | How is a database trigger used? |
| A1: | A database trigger takes a specified action when data in a specified table is manipulated. For instance, if you make a change to a table, a trigger could insert a row of data into a history table to audit the change. |
| 2: | Can related procedures be stored together? |
| A2: | Related procedures can be stored together in a package. |
| 3: | True or false: Data Manipulation Language (DML) can be used in a PL/SQL statement. |
| A3: | True. |
| 4: | True or false: Data Definition Language (DDL) can be used in a PL/SQL statement. |
| A4: | False. DDL cannot be used in a PL/SQL statement. It is not a good idea to automate the process of making structural changes to a database. |
| 5: | Is the capability of outputting text on the screen contained ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
