databases Online Quiz - 104
|Description: databases Online Quiz - 104|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
How many LONG columns are allowed in a table ?
The data contained in Materialized view will be deleted automatically if the base tables will be deleted?
Find the error in the line for the query written below?
Can a view be created be based on another view definition?
Does the view exist if the table is dropped from the database?
Is this a valid join condition written in the query below?
Can we create index on Materialized Views?
The RowID can be changed for the particular row whenever any insert or update operation is performed on the table?
Which of the following will be a better compilation methodology for a Procedure that involves only looping structures.
You can commit inside a trigger
The keyword IS & AS in Procedure definition
Native dynamic sql works faster than dbms_sql
If a procedure that has overloaded procedures is called
Which is performance friendly
ascii() function would display the corresponding ASCII code of the string enclosed
In Program overloading, You have two procedures with same name. which of the following will not work
CURSOR FOR loop can be opened with the command...
In Oracle 9i, we can specify the FIRING order in which the that are created on a table
procedure to create a customized ERROR message
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.
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.