Tag: databases

Questions Related to databases

  1. Yes, there is a workaround, but not directly

  2. yes directly

  3. no

  4. I dont Know


Correct Option: A
  1. Both are same

  2. IS will only work

  3. AS will only work

  4. Both cannot be used in procedure definition


Correct Option: A
  1. Normal Procedure

  2. Overloaded Procedure

  3. Packaged Procedure

  4. None of these


Correct Option: C
  1. VARRAY

  2. PL/SQL TABLE

  3. NESTED TABLE

  4. NONE OF THESE


Correct Option: A
  1. Having the data type different

  2. Just interchange the input parameter

  3. having the name diffferent

  4. both a & b


Correct Option: B
  1. OPEN

  2. FETCH

  3. PARSE

  4. None, cursor for loops handle cursor opening implicitly


Correct Option: D