SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 179605

What is the difference between anonymous block and named blocks?

3 10473

what is inline view?

15 41328

what is the difference between implicit conversions and explicit conversions?

2 9094

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 14101

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 ?

Oracle,

3 8771

What is Referential Integrity?

3 7906

can we update a view which is created from two tables

11 33604

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.

Oracle,

9 15596

Can u create a primary key with out unique index.

8 14551

what are the demerits of sql?

1 5246

what is the difference between binary_integer and pls_integer

TCS,

2 32206

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

Microsoft,

2529

What cursor type do you use to retrieve multiple recordsets?

Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

17 69936

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56340

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is forward declaration in pl sql?

1008

What is triggering circuit?

1017

What are the constraints available in sql?

999

how to extract a unit value from a date and time? : Sql dba

948

Is and as keyword in pl sql?

908

what is a database? : Sql dba

1101

How do I find duplicates in the same column?

1000

What is information schema in sql?

1017

What are operators available in sql?

983

Explain autonomous transaction.

1095

What does select top 1 do in sql?

1007

Why we use pl sql?

908

What is rank () in sql?

885

Explain raise_application_error.

1044

Name some usages of database trigger?

969

For More Un-Answered { SQL PLSQL } Questions Click Here