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 180553

What is the difference between anonymous block and named blocks?

3 10635

what is inline view?

15 41964

what is the difference between implicit conversions and explicit conversions?

2 9227

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 14408

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 8933

What is Referential Integrity?

3 8045

can we update a view which is created from two tables

11 34069

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 15926

Can u create a primary key with out unique index.

8 14875

what are the demerits of sql?

1 5347

what is the difference between binary_integer and pls_integer

TCS,

2 32368

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

Microsoft,

2571

What cursor type do you use to retrieve multiple recordsets?

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

17 70777

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56657

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Does sql*plus also have a pl/sql engine?

1079

What is the difference between nested table and varray?

1003

What is the use of index in sql?

1017

What sql database should I use?

1143

What is set serveroutput on in pl sql?

1296

How do I run sql?

1183

What language is oracle sql developer?

1017

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

How to run pl sql program in mysql?

1020

How do I partition in sql?

963

Explain lock escalation? : Transact sql

1197

Are views faster than queries?

992

What do you mean by “trigger” in sql?

1079

What is sqlexception in java?

989

What is an ndf file?

994

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