| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ? | PreVator | 4 |
| What is a self join ? | BirlaSoft | 5 |
| can we use out parameter in a function?Give an example. | Logica-CMG | 2 |
| I have a small PL/SQL Block
assume in this way
begin
select * from emp where empno=100;
exception
when others then
<Some Messages>
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
end;
The question which he asked was whether this block will get
executed normally or it will throw error ?
If errored out then what is the reason for the error ?
Could anybody please help me ?
Regards
Nakul Venkataraman | Satyam | 3 |
| suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary | | 3 |
| what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found ) | Tech-Mahindra | 1 |
| 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 clustered, non-clustured and unique index. How many
indexes can be created on a table ? | TCS | 2 |
| What are the new features in Oracle 10g. Compared to Oracle
9i? | Polaris | 1 |
| What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ? | | 1 |
| what is constraining table? | | 1 |
| What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ? | | 1 |
| What is difference between TRUNCATE & DELETE? | TCS | 12 |
| hi this is nakka i have been looking for 1+ exp in oracle
sql,plsql developer positions also have knoledge on d2k
i am not getting proper walkins how to know it? where can
i find it? | | 1 |
| what are the forced views | Hexaware | 3 |
| SELECT flavor, SUM (ice_cream_sales) FROM sales_detail
GROUP BY flavor ORDER BY 2 DESC
If the "sales_detail" table contains ten records with
different values in the flavor column (two "vanilla,"
three "chocolate," four "strawberry," and one NULL), how
many rows are returned by the sample code above?
1. 0 rows
2. 1 row
3. 3 rows
4. 4 rows
5. 10 rows
| Sonata | 7 |
| Can we use SQL%ISOPEN in implicit cursors? Does this
attribute works properly in Implicit Curosors? | | 2 |
| Give an example of any procedure. | iFlex | 3 |
| Give which cursor is better for better performance means
type of cursors? | | 2 |
| What are the differences between Database Trigger and
Integrity constraints ? | | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
