Total Pageviews

February 8, 2015

2/08/2015 09:46:00 AM

Oracle Interview Questions
How do u get the third highest salary?

Difference between UNION and UNION ALL

A form has master and detail block, when I query the master block, it should query only master records, not detail records and when I take the cursor in detailed block then only it should query detailed block. How will u achieve it?

How will u call a form from another form ?

Can we create 2 LOV’s on a single record Group?

What is Property Class in forms?

What are the triggers in reports?

I have created a report with a query written in it. when I run this report, if there are no records, then that report will show blank, but I want to see the text on the report….’No Data Found’, How will u achieve it?

What is the difference between CALL_FORM, OPEN_FORM and NEW_FORM?
If we create a form based on a complex view, then how will u insert, update, delete the records?

send your answers to sekhar.byna@gmail.com

*****You can find second set of questions*****
Set 2



create table atest(a varchar2(20))


insert  into atest values('a');


alter table atest
modify a Number;

Is it right statement?

2)
create table atest(a number,sal number)

create view atest_v as select a,sal,(sal*.1) comm from atest

insert into atest values(10,1000);
then what is the value of comm?

3)for the same q2
update emp set comm=1000 where a=10;
then what is the value of sal?

4)create table atestv as select * from atest_v;
update atest_v set sal=800 where a=10,
commit;
then what is the value of sal in the atestv?

5)create table emptest
( a number primary key) how many indexes will be created?

6)Can I update rowid?

7)CREATE OR REPLACE FUNCTION afun1 (a NUMBER)
   RETURN NUMBER
IS
   b   NUMBER;
   c number;
BEGIN
c:=a*10;
   b := afun1(c);
   RETURN b;
END afun1;
what is the ouput ?
Need to justify your answer?
8)CREATE OR REPLACE FUNCTION afun1 (a IN NUMBER)
   RETURN NUMBER
IS
BEGIN
   RETURN 10;
   DBMS_OUTPUT.putline (a * 10);
END afun1;
what is the output?

9)what is sequence;
I am using sequence in emp table
ex:
insert into emp values(emp_s.nextval,'test');
if update empno is the sequence value will be incremented by the same value?