Day 5
Quiz
| 1: | What are the three types of data integrity? |
| A1: | The three types of data integrity are entity or table integrity, domain or column integrity, and referential integrity. |
| 2: | True/False. A CHECK() constraint is checked after the triggers. |
| A2: | False. Constraints are checked before the trigger. If the data violates the constraint, the data is rejected and the trigger is not invoked. |
| 3: | Which DML statements can be turned into a stored procedure with the help of the stored procedure wizard? |
| A3: | Using the stored procedure wizard, you can create a stored procedure containing an INSERT, UPDATE, or DELETE statement against any table you select . |
| 4: | How do you retrieve the value of the identity column after you insert a row in a table? |
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days 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.
