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
     



    Oracle PL. SQL Interactive Workbook
    Oracle PL/SQL Interactive Workbook (2nd Edition)
    ISBN: 0130473200
    EAN: 2147483647
    Year: 2002
    Pages: 146

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net