| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| wht is the difference between sqlaserver2000 and 2005 | ABC | 1 |
| What is TABLE SPACE? | ABB | 2 |
| Explain the usage of WHERE CURRENT OF clause in cursors ? | | 2 |
| if i perform any operation on views such as insert, delete
etc will my base table get affected????? | | 3 |
| select 1,col1,col2 from table1. output? | Ramco | 3 |
| Can we write create command in the plsql block?if possible
how? | | 2 |
| What are the advantages of the packages | Oracle | 4 |
| If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE? | | 2 |
| What is clustered and non-clustered indexes? | Microsoft | 3 |
| Give the structure of the procedure ? | | 1 |
| Explain the two type of Cursors ? | Hi-Caliber-IT | 4 |
| What cursor type do you use to retrieve multiple recordsets?
| Microsoft | 9 |
| 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 |
| How to convert ms-excel file to oracle table? | | 2 |
| how to create object in plsql | Microsoft | 1 |
| What is a join?Explain the different types of joins? | Saama-Tech | 3 |
| I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
| Polaris | 1 |
| difference between cursor and procedure in a package | | 2 |
| What is Pragma EXECPTION_INIT ? Explain the usage ? | | 1 |
| What is the difference between RDBMS and DBMS? | Stag-Computers | 5 |
| |
| For more SQL PLSQL Interview Questions Click Here |