| Other SQL PLSQL Interview Questions |
|| Asked @
|Can a view be updated/inserted/deleted?If Yes under what
|how to find the second highest salary from emp table?
|What does “select count(1) from tab” result?
|scope of exception handling in plsql
|What are the return values of functions SQLCODE and SQLERRM ?
|write a query to delete similar records in different tables
with same structure
|How many database objects (trigger, packages, sequence etc)
particular field in a given table.
For ex: I want to know how many database object uses the
the PO_VENDORS table.
What query will give me the result showing the database
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
|Where the Pre_defined_exceptions are stored ?
|What is Raise_application_error ?
|what is the main difference between join and subqurey?
|Can we use more than one null value for unique key?
|What are the difference between Functions/Stored Procs and
Triggers and where are they used.
|For more SQL PLSQL Interview Questions Click Here |