databases Online Quiz - 104
|Description: databases Online Quiz - 104|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
The data contained in Materialized view will be deleted automatically if the base tables will be deleted?
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?
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
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
CURSOR FOR loop can be opened with the command...
procedure to create a customized ERROR message
Which of the following is false statement of the package.