| Other SQL PLSQL Interview Questions |
|| Asked @
|What are all the difference between Like and Contains ?
|What is the maximum number of triggers,can apply to a single
|List the differences between plsql - function & procedures
|What is Highwatermark?
|how to create a database in oracle?please gve anser with example
|What are the default Oracle triggers??
|1. how to use the check option constraints in sql query..?
2.how to add data in a complex query ?
3.is it possible to use commit or rollback or savepoint in
triggers...if not why please explain with examples...?
4.what is the difference between meterialized view and
normal view..how to create materialized view and how to use
5.what is varray...? what is the advantage of the varray ?
please expalin with a simpel example..i want to load into a
table (student no and name and his marks..) please give
6.what are the bulk bind exceptions...how to use bulk bind
and how to use bulk collect..please explain with example...
7.what is for update of and where current of ...?
8 what is the use of nowait ?
9.please give an example for nocopy in a simple plsql query
10.create an index in a table...tellme how to use the
index in a where clause to do performance tunning...
|what is bulk bind
|Can we use more than one null value for unique key?
|Query for second maximum salary in each in each department
|What is a cursor ? Why Cursor is required ?
|What is the first action to perform a query?
Suppose I have four tables and five joins and my query is
getting slow day by day.
|For more SQL PLSQL Interview Questions Click Here |