| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the differences between Database Trigger and
Integrity constraints ? | | 3 |
| What is Overloading of procedures ? | | 1 |
| in materialized view the structure will create immediately
or not? | iFlex | 2 |
| Please let me know if UNION ALL and Natural Join does the
same operation and are same... | iGate | 3 |
| What are the advantages of the packages | Oracle | 4 |
| Find out the 3rd highest salary? | BirlaSoft | 14 |
| Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ? | | 3 |
| What are advantages of Stored Procedures? | Satyam | 2 |
| Whatis yhe use of cursor ? how cursor allocate context area
for executing the sql statement? | HCL | 2 |
| What is PL/SQL table ? | | 2 |
| difference between cursor and procedure in a package | | 2 |
| in a package one procedure is wrong package shows valid or not | | 2 |
| What is a package ? What are the advantages of packages ? | Symphony | 1 |
| what eliminate duplicate without using roenum and not | Matrix | 3 |
| Types of cursors and explanation each of them ? | DELL | 1 |
| What is pl/sql and what is it used for? | | 2 |
| I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL
COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT | AOL | 1 |
| what is difference between "Primary key" and "Unique key"? | PreVator | 4 |
| what is variable in package specification | | 2 |
| I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees. | Wipro | 7 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Site Map