Chapter 4 SQL in PL/SQL Lab 4.1 Self-Review Answers | | | | | | | | | | | | | A4: | | Questions | Answers | Comments | | 1) | B, D | | | 2) | A, D | You cannot create a table or sequence within a PL/SQL block. | | 3) | C | | | 4) | A, B, D | A sequence will generate unique numbers , but you cannot count it as a method to generate contiguous number. | | Lab 4.2 Self-Review Answers | | | | | | | | | | | | | A4: | | Questions | Answers | Comments | | 1) | B | When you issue a ROLLBACK it only applies to the current session of the user you are logged in as. It has no effect on other sessions. | | 2) | A, C | | | 3) | D | | | 4) | B | | | |