Java PLSql Mcq answers

PL/SQL Quiz


  1. All

  2. False -> function return

  3. True -> DML

  4. Return

    5.Return Varchar2 -> return variable (longer question)

​ 

Cursors


  1. exit when SQL%NOTFOUND

  2. Cursor

  3. None of the above

  4. true - sql cursor

  5. false - begin block

​

Exception Handling

​


  1. true - raiseapplicationerror

  2. calling environment

  3. SQLCODE

  4. 0 - explicitly

  5. At the end


SP and Functions

​


  1. return varchar2

  2. all of the above - named block

  3. all of the above - trigger

  4. false

  5. an execution of a specific probably