| Other SQL PLSQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| What is Difference between StoredProcedure and function? |
| 3 |
| How would you hide a table in sql. ie the table can be only
visible to its maker? |
| 3 |
| I have done oracle 10g. I need a project knowledge. So if u
please send a project how it should be done,Or you can send
email link. I will be very grateful to u. |
| 1 |
| if i perform any operation on views such as insert, delete
etc will my base table get affected????? |
| 4 |
| 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 |
TCS | 2 |
| how to create object in plsql |
Microsoft | 3 |
| What are the different types of joins and explain them
briefly.
|
| 3 |
| hi this is nakka i have been looking for 1+ exp in oracle
sql,plsql developer positions also have knoledge on d2k
i am not getting proper walkins how to know it? where can
i find it? |
| 5 |
| Explain how procedures and functions are called in a PL/SQL
block ? |
| 2 |
| what is global table |
iFlex | 5 |
| How many rows will return from dual table? |
Fujitsu | 3 |
| How do you handle exceptions. Give the syntax for it? |
Microsoft | 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |