Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Oracle SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is correlated sub-query?

 7 39674

how instead of triger is helpful for mutating tables errors handlling ?

 2 9350

What are the advantages of the packages

 6 10134

what are the advantages of primary key over unique+notnull

 7 20019

how to retrieve the top 3 salaries of the table using rownum

 31 33780

what is the difference between union and union all

 14 42036

What is the difference between join and union.

 27 172784

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 ?

7 12092

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 7740

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

 9 13141

What cursor type do you use to retrieve multiple recordsets?

17 64625

Two Methods of retrieving SQL?

 7 53865

How do you optimize SQL queries ?

 6 33203

How well can multiple sessions access the same data simultaneously ?

 1 2653

Delete duplicate records in the emp table.

 6 12967

Post New Oracle SQL PLSQL Interview Questions


Oracle SQL PLSQL Interview Questions


Un-Answered Questions

What is the use of log files?

480

What do you mean by mail merge in ms word?

321

What is difference between 'protocol' and 'delegate'?

447

What does django mean?

190

What language are windows batch files written in?

403




what is a view? : Sql dba

628

What are the applications of linked list?

475

What is tri state of a signal?

598

Mention the differences between unique key and primary key

465

What are the different types of annotations in spring?

150

how the synchronizing is obtained at bus couplers in grid substation? (because there we cannot change the frequency in one of transmission lines like in generator synchronization)

1846

Explain the criteria object in hibernate?

196

Tell me is a web site on wordpress secure?

88

what is the memory required when a screen has 1024*1280 pixels and each pixel can have around 16 million colors?

550

What is the meaning of floating point earthing in battery backed systems ?

1470