| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ? | IBM | 7 |
| Types of backups ? | TCS | 3 |
| Differences between UNIQUE and DISTINCT in select statements | Verinon-Technology-Solutions | 9 |
| Is it possible to use LONG columns in WHERE clause or ORDER
BY? | | 1 |
| what are the advantages of package?
| iFlex | 5 |
| In testing where do we use sql language and how it helps in
testing? | | 2 |
| scope of exception handling in plsql | Wipro | 2 |
| What is difference between a PROCEDURE & FUNCTION ? | Satyam | 3 |
| In a package if we have 10 procedures or functions,How to
know which will execute first? | | 1 |
| hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com | Wipro | 2 |
| can i call procedure in package | TCS | 2 |
| Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ? | | 3 |
| Which one of the following is a reason that an INSERT
statement might cause an error instead of executing
correctly?
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
2. The INSERT statement was attempting to insert a record
using a combination of constants and values from an
existing table.
3. The INSERT statement was attempting to insert a record
with a non-NULL value into a table that has that column
defined as NULL.
4. The INSERT statement was attempting to insert a record
into a table by selecting a record from that same table.
5. The INSERT statement was attempting to insert a record
into a view rather than a table.
| Sonata | 1 |
| how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance | | 3 |
| What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ? | | 1 |
| What are the blocks in stored procedure? | Microsoft | 2 |
| What is the difference between SQL table and the PLSQL
table? | Mastek | 1 |
| What is TABLE SPACE? | ABB | 2 |
| What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet? | Oracle | 2 |
| what is called after appearing where clause | | 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
