Chapter 4 SQL in PLSQL

Team-Fly

---

	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:

Questions	Answers	Comments
1)	B, D

A2:

Questions	Answers	Comments
2)	A, D	You cannot create a table or sequence within a PL/SQL block.

A3:

Questions	Answers	Comments
3)	C

A4:

Questions	Answers	Comments
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:

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.

A2:

Questions	Answers	Comments
2)	A, C

A3:

Questions	Answers	Comments
3)	D

A4:

Questions	Answers	Comments
4)	B

---

Team-Fly

Top