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

The data contained in Materialized view will be deleted automatically if the base tables will be deleted?

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B

Does the view exist if the table is dropped from the database?

  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

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

  1. NATIVE

  2. INTERPRETTED

  3. BOTH

  4. NONE


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

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

Which is performance friendly

  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

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

  1. OPEN

  2. FETCH

  3. PARSE

  4. None, cursor for loops handle cursor opening implicitly


Correct Option: D

procedure to create a customized ERROR message

  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