| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| declare
l1 number := null;
l2 number :=null;
begin
if l1=l2 then message('equal');
else
if l1<>l2 then message('not equal');
else
message('else');
end if;
end if;
end;
What will be the output ?
| Oracle | 7 |
| What is the result, when NULL is compared with NULL? | TCS | 10 |
| What is a cursor for loop ? | | 2 |
| How do you handle exceptions. Give the syntax for it? | Microsoft | 1 |
| 1 SELECT a.field1, b.field2, c.field3, d.field4
2 FROM atable a, atable b, ctable c, dtable d
3 ?
4 ORDER BY 1
What is the minimum number of joins that must be specified
on line 3 in the sample code above to properly link the
tables? Notice that the table "atable" is aliased twice:
once as "a" and once as "b."
1. One join
2. Two joins
3. Three joins
4. Four joins
5. Five joins
| Sonata | 3 |
| What are the datatypes a available in PL/SQL ? | | 2 |
| When would you denormalize? | Microsoft | 4 |
| Write a query to get 2nd maximum salary in an employee table ? | TCS | 19 |
| 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 |
| write a query to delete similar records in particular
fields(columns) in different tables | | 2 |
| How do you get all records from 2 tables. Which join do you use? | Microsoft | 3 |
| Explain how procedures and functions are called in a PL/SQL
block ? | | 1 |
| what is difference between procedure and function | Wipro | 4 |
| what is the difference between granting and creating a view? | | 1 |
| What are user defined stored procedures ? | BirlaSoft | 2 |
| What are the PL/SQL Statements used in cursor processing ? | | 2 |
| What is Raise_application_error ? | | 1 |
| define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more. | | 2 |
| Where the integrity constrints are stored in Data
Dictionary? | | 1 |
| If a View on a single base table is manipulated will the
changes be reflected on the base table? | | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map