0

databases Online Quiz - 104

Description: databases Online Quiz - 104
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Can a view be created be based on another view definition?

  1. True

  2. False


Correct Option: B

Is this a valid join condition written in the query below?

  1. True

  2. False


Correct Option: B

The RowID can be changed for the particular row whenever any insert or update operation is performed on the table?

  1. True

  2. False


Correct Option: B

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
  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

If a procedure that has overloaded procedures is called

  1. Normal Procedure

  2. Overloaded Procedure

  3. Packaged Procedure

  4. None of these


Correct Option: C

Which is performance friendly

  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
  1. RAISE_ERROR

  2. SQLERRM

  3. RAISE_APPLICATION_ERROR

  4. RAISE_SERVER_ERROR


Correct Option: C

Which of the following is false statement of the package.

  1. Dependency simplified

  2. Loaded once into memory , used subsequently

  3. Privileges to objects cannot be controlled

  4. Encapsulation of code logic


Correct Option: C
- Hide questions