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 

Get Oracle® PL/SQL® Interactive Workbook, Second Edition 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.

Start your free trial