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

Which of the following is false statement of the package.