Tag: databases

Questions Related to databases

You can commit inside a trigger

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

  2. yes directly

  3. no

  4. I dont Know


Correct Option: A

The keyword IS & AS in Procedure definition

  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

Native dynamic sql works faster than dbms_sql

  1. True

  2. False


Correct Option: B
  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

ascii() function would display the corresponding ASCII code of the string enclosed

  1. True

  2. False


Correct Option: B
  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

In Oracle 9i, we can specify the FIRING order in which the that are created on a table

  1. True

  2. False


Correct Option: B