| Other SQL PLSQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| how to retrieve only duplicate values in a table |
| 7 |
| What is a database link? |
| 2 |
| IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY?????? |
rsystems | 6 |
| what is inline view? |
| 15 |
| What is a database trigger ? Name some usages of database
trigger ? |
| 4 |
| hi
sql gurus, here is my question 4 u.
i wanna use triggers for sending reminder mail to all users
who are registered to the site. if any one knws the code plz
send me ans here : chayabs3@gmail.com
thnx advance
|
| 1 |
| select * from emp where sal in(select max(sal) from emp)
here there is any limit for in operator how many values
accpect ? |
| 2 |
| What are the Restrictions on Cursor Variables? |
| 2 |
| Types of cursor locks and explanation each of them ? |
DELL | 3 |
| how a reference cursor works?what all adnvantages are
gained with it..specify the situation? |
TCS | 3 |
| Give an example of Full Outer Join?
|
IBM | 1 |
| If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again? |
TCS | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Site Map
