| Oracle® PL/SQL® Interactive Workbook, Second Edition
By
Benjamin Rosenzweig, Elena Silvestrova
| | Table of Contents | |
Appendix A.
Answers to Self-Review Questions |
Chapter 4 SQL in PL/SQL
Lab 4.1 Self-Review Answers | | A1:
| | | | A2:
| |
2) |
A, D |
You cannot create a table or sequence within a PL/SQL block. |
| | | A3:
| | | | A4:
| |
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 | | A1:
| |
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. |
| | | A2:
| | | | A3:
| | | | A4:
| |
|
|
| |
No comments:
Post a Comment