Honeywell PLSQL Interview Questions
Honeywell PL/SQL Interview Questions
- DIFFERENCE between subquries and co-related sub quries..
- How u find which process is running in unix environment?
- Whether grep() provide no of times of patrren searching?
- Difference b/w procedure and function?
- Joins-----types –with explanation
- Scenario to find quries using outer joins
- Highest & lowest salary values
- Find the second maximum salary
- Datatypes in sql
- Package advantages
- Trigeer –types
- Nvl function
- Pragma
- Cursor types
- How to debug a procedure
- Difference b/w union and union all?
- Without producing a link how u send data to front end manually?
- How to find how many records it fetched?
- How u get where error is occurred in code?
- What is data dictionary?
- Single row,multi row functions/
- Difference b/n view and materialized view?
- Psuedo columns
- Decode ()
- Sequence, advantages
- Explain set operations?
- Inline function()
- Difference b/n nullif and nvl2
- Difference b/n dbms and rdbms
- Diffence b/n count(1),count(*)
- PROCEDURE overloading
- date fuctions?
- Loops in plsql
- what is table space?
- difference b/n having and where caluse?
- Dis advantages of cursor
- bulk loader
- bulk collect
- triggers/instead of trigger
- creation of data base link
- use of hint
- What is directory?
- What is external table?
*/
No comments:
Post a Comment