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

How many LONG columns are allowed in a table ?

  1. 0

  2. 1

  3. 8

  4. Any number


Correct Option: B

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

  1. True

  2. False


Correct Option: B

Find the error in the line for the query written below?

  1. Line 1

  2. Line 2

  3. Line 3

  4. Line 4


Correct Option: D

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

Can we create index on Materialized Views?

  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

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

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

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

  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

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

procedure to create a customized ERROR message

  1. RAISE_ERROR

  2. SQLERRM

  3. RAISE_APPLICATION_ERROR

  4. RAISE_SERVER_ERROR


Correct Option: C

AI Explanation

To create a customized error message in Oracle PL/SQL, you can use the RAISE_APPLICATION_ERROR procedure.

The correct answer is C) RAISE_APPLICATION_ERROR.

Explanation:

Option A) RAISE_ERROR - This option is incorrect because there is no built-in procedure called RAISE_ERROR.

Option B) SQLERRM - This option is incorrect because SQLERRM is a function that returns the error message associated with the most recently raised error. It does not allow you to create a customized error message.

Option C) RAISE_APPLICATION_ERROR - This option is correct because the RAISE_APPLICATION_ERROR procedure allows you to raise a user-defined exception and specify a customized error message along with an error code. You can use this procedure to create a customized error message.

Option D) RAISE_SERVER_ERROR - This option is incorrect because there is no built-in procedure called RAISE_SERVER_ERROR in Oracle PL/SQL.

Therefore, the correct answer is C) RAISE_APPLICATION_ERROR.

  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