PL/SQL (Advanced) Online Test

At which place overloaded modules CANNOT be used :


Record Type is "known and visible" to


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


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


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?


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


Where is UGA located ?


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


Which is NOT true among the following:


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


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


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


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


Which dictionary view track dependencies?


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


Which is NOT a valid way to minimize dependency failure?


Which is NOT true among the following :


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


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


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


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


APPEND_VALUES hint has been introduced in Oracle 11g?


























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