| Other SQL PLSQL Interview Questions |
|| Asked @
|what is organisational index?
|How will you delete a particular row from a Table?
|I have a small PL/SQL Block
assume in this way
select * from emp where empno=100;
when others then
when no_data_found then
when too_many_rows then
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 ?
|what is the main difference between join and subqurey?
|What is an index and types of indexes. How many number of
indexes can be used per table ?
|What is pseudo column ?
|what is SCALAR Queries?
|How will you a activate/deactivate integrity constraints?
|function can return value ,procedure also return value through
out parameter then what is the difference?
|Difference between DBMS and RDBMS...CODD's rules
|what is constraining table?
|What is correlated sub-query?
|For more SQL PLSQL Interview Questions Click Here |