| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is clustered and non-clustered indexes? | Microsoft | 3 |
| Types of joins ? | Digital-GlobalSoft | 3 |
| Types of backups ? | TCS | 3 |
| 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 |
| declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i into lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end loop;
message(num);
What will be the output ?
| Oracle | 2 |
| why should required for Indexed by table in pl/sql | | 2 |
| What are the modes of parameters that can be passed to a
procedure ? | | 2 |
| Give an example of any procedure. | iFlex | 2 |
| What are the differences between Database Trigger and
Integrity constraints ? | | 3 |
| What are two virtual tables available during database
trigger execution ? | | 2 |
| what eliminate duplicate without using roenum and not | Matrix | 4 |
| If I have a table T with 4 rows & 2 columns A & B. A has
values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL
query which can Swap the values of A & B for all records.
(Do not use a sub-query) | | 2 |
| Please let me know if UNION ALL and Natural Join does the
same operation and are same... | iGate | 3 |
| What is Referential Integrity? | | 2 |
| What is a transaction? | | 4 |
| Types of indexes. What is the default key created when a
primary key is created in a table ? | TCS | 4 |
| write a query to delete similar records in particular
fields(columns) in different tables | | 2 |
| i have a table with column sno with 30 records. i want to
update this column by item by item in asp.net. i wantto
enter new values into that from 1 to 30 how is it possible
with backend c# | | 1 |
| how to get second highest salary in SQL(as/4000 | iGate | 14 |
| If you want a column to be part of the result set, after
which SQL keyword does it belong?
1. SELECT
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
| HCL | 9 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Site Map
