Tag: databases

Questions Related to databases

Which of the following will be a better compilation methodology for a Procedure that involves only looping structures.
technology databases

  1. NATIVE

  2. INTERPRETTED

  3. BOTH

  4. NONE

Show answer
Correct Option: A

You can commit inside a trigger

technology databases

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

  2. yes directly

  3. no

  4. I dont Know

Show answer
Correct Option: A

The keyword IS & AS in Procedure definition

technology databases

  1. Both are same

  2. IS will only work

  3. AS will only work

  4. Both cannot be used in procedure definition

Show answer
Correct Option: A

Native dynamic sql works faster than dbms_sql

technology databases

  1. True

  2. False

Show answer
Correct Option: B

If a procedure that has overloaded procedures is called
technology databases

  1. Normal Procedure

  2. Overloaded Procedure

  3. Packaged Procedure

  4. None of these

Show answer
Correct Option: C

Which is performance friendly
technology databases

  1. VARRAY

  2. PL/SQL TABLE

  3. NESTED TABLE

  4. NONE OF THESE

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

In Program overloading, You have two procedures with same name. which of the following will not work
technology databases

  1. Having the data type different

  2. Just interchange the input parameter

  3. having the name diffferent

  4. both a & b

Show answer
Correct Option: B

CURSOR FOR loop can be opened with the command...
technology databases

  1. OPEN

  2. FETCH

  3. PARSE

  4. None, cursor for loops handle cursor opening implicitly

Show answer
Correct Option: D

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B