| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| I have a procedure in a procedure. The inner procedure
contains out parameter. How I can call the inner procedure
in the out procedure and send the inner procedure parameter
value(out parameter value) into out procedure? | | 1 |
| How can I pass the inner procedure value to outer
procedure ? | | 2 |
| Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
| HCL | 5 |
| what are the different types of joins? | Choice-Solutions | 3 |
| When would you denormalize? | Microsoft | 4 |
| What is the main difference between a UNION statement and a
UNION ALL statement?
1. A UNION statement eliminates duplicate rows; a UNION
ALL statement includes duplicate rows.
2. A UNION statement can be used to combine any number of
queries; a UNION ALL statement can be used to combine a
maximum of two queries.
3. A UNION statement can only combine queries that have
parallel fields in the SELECT list; a UNION ALL statement
can combine queries with differing SELECT list structures.
4. A UNION statement cannot be used with aggregate
functions; a UNION ALL statement can be used with aggregate
functions.
5. There is no difference between the two statements; they
are interchangeable.
| Sonata | 2 |
| what is the difference between implicit conversions and
explicit conversions? | | 1 |
| What is the best strategy to use COMMIT in a pl/sql loop? | | 2 |
| what is variable in package specification | | 2 |
| How to execute OS(operating system) command from pl/sql? | | 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 |
| What is pseudo column ? | ABB | 2 |
| write the Sql query for creating database backup? | TCS | 3 |
| 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 |
| Does SQL*Plus contains pl/sql Engine? | TCS | 1 |
| What is the Subquery? | | 2 |
| What is the difference between anonymous block and named
block or stored procedure? | | 5 |
| What is correlated sub-query? | | 3 |
| How many database objects (trigger, packages, sequence etc)
uses a
particular field in a given table.
For ex: I want to know how many database object uses the
ATTRIBUTE1 in
the PO_VENDORS table.
What query will give me the result showing the database
object
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
PO_VENDORS).
| IBM | 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 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
