• databases Online Quiz - 104
Back
0

databases Online Quiz - 104

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

How many LONG columns are allowed in a table ?
technology databases

  1. 0

  2. 1

  3. 8

  4. Any number

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: B

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

  1. Line 1

  2. Line 2

  3. Line 3

  4. Line 4

Show answer
Correct Option: D

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

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can we create index on Materialized Views?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: B

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

procedure to create a customized ERROR message

technology databases

  1. RAISE_ERROR

  2. SQLERRM

  3. RAISE_APPLICATION_ERROR

  4. RAISE_SERVER_ERROR

Show answer
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.

Which of the following is false statement of the package.

technology databases

  1. Dependency simplified

  2. Loaded once into memory , used subsequently

  3. Privileges to objects cannot be controlled

  4. Encapsulation of code logic

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions