Chapter 4 SQL in PLSQL

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