Sunday, September 25, 2016

3i-infotech Oracle SQL PL/SQL Interview Questions

3i-infotech Oracle SQL PL/SQL Interview Questions

Explain your project
difference between case and decode
difference between procedure and package
select * from emp what are the steps to follow sql engine to display the output
what is parsing and types of parsing
what is materialized view
what is the use of forward declaration
can we use commit in trigger, without pragma can we commit trigger it is compile or not.
we are using :old,:new , before trigger processing  what is the value of :new.
create table a;
delete from b(10 records);
roll back;
select count(*) from b; what is the output

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts