Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources]

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.

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