PL/SQL (Advanced) Online Test

APPEND_VALUES hint has been introduced in Oracle 11g?


Which choice is incorrect amonng the following after dropping a table using DTOP TABLE statement?


Which keyword is used to update an entire row of a table using a record type variable ?


What happens when SELECT...INTO is nuable to find any rows ?


Where should you put WHEN OTHERS EXCEPTION clause so as to avoid compilation error:


Which is NOT true among the following :


Which is NOT a valid way to minimize dependency failure?


What part of a database trigger determines the number of times the trigger body executes?


Which dictionary view track dependencies?


Functions can be invoked in SQL statements unless they return a non-server data type, such as:


What is the main difference b/w deterministic and result_cache functions in terms of caching benefit they offer:


PL/SQL pipelined functions gives the ability to issue statement like : select * from SOME_PLSQL_FUNCTION;


A function having OUT or IN OUT parameters, cannot be called from withing a SQL.


Which is NOT true among the following:


Which objects we CANNOT declare in PL/SQL Package specification ?


Where is UGA located ?


Which among the folloiwing is NOT a benefit of Packages in PL/SQL :


You are in the process of dropping the BUILDING_LOCATION column from the HR.EMPLOYEES table.

The table has been marked INVALID until the operation completes. Suddenly the instance fails.

Upon startup, the table remains INVALID. Which step(s) should you follow to complete the operation?


What is the permitted number of maximum Columns in a base table :


Can we use dbms_utility.exec_ddl_statement to execute a DDL statement ?


Record Type is "known and visible" to


At which place overloaded modules CANNOT be used :


























Description:

There are 19 questions in this quiz. This contains advanced topic questions also. Questions are of 11g level too.
There are 19 questions in this quiz. This contains advanced topic questions also. Questions are of 11g level too.
There are 19 questions in this quiz. This contains advanced topic questions also. Questions are of 11g level too.
There are 19 questions in this quiz. This contains advanced topic questions also. Questions are of 11g level too.

Discussion

Your Facebook Friends on WizIQ