HP PLSQL Interview Questions

HP PL/SQL Interview Questions

• wt is the diff b/w greast and max ,least and min? Wt is the diff b/w case and decod?
• how to print * ** *** **** ***** by using sql query?
• Write a query to filter improper date format following table?

Date
20-apr
22-may-2010
26-jun-2010
Feb-2009

I want the output

Date
22-may-2010
26-jun-2010

• Write a query to remove  null following table are

Id    name
101   dinesh
Null  jyothi
Null  bharathi
102   suresh
Null  shilpha
103   prakesh
Null   suma

I want the output format like

Id     name
101    dinesh
102    suresh
103    prakesh

• Wirte a query  to remove null? Following table are

Col1   col2   col3
Dinesh null   null
Null   suresh  null
Null   null    prakesh

I want the output like

 Col1    col2    col3
Dinesh  suresh   prkaesh

• Write a query   filter the null value data following source?

Name  age
John  30
Smith null
Null  24
Sharp 35
I want output

Name age
John 30
Sharp 35

• When do we create bitmap indexes
• Can we use out parameter in function?
• Write a query to generate target column.

Src      target
Q10  quarter to 2010
Q90  quarter to 1990
Q80  quarter to 1980
Q74  quarter to 1974

• How to call the function and procedure in trigger?
• What is different between union and minus?
• Can we interchange parameters in procedure while calling
• what is 'force view'?
• What are global temporary tables
• What are nested tables? How will u delete 5 rows from nested
• select top 3 sal from each dept?
• what is difference between having and where clause?
• Can you have multiple sps with the same name on a database?