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 181255

What is the difference between anonymous block and named blocks?

3 10748

what is inline view?

15 42369

what is the difference between implicit conversions and explicit conversions?

2 9319

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 14587

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 9046

What is Referential Integrity?

3 8158

can we update a view which is created from two tables

11 34387

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 16133

Can u create a primary key with out unique index.

8 15081

what are the demerits of sql?

1 5431

what is the difference between binary_integer and pls_integer

TCS,

2 32494

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

Microsoft,

2608

What cursor type do you use to retrieve multiple recordsets?

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

17 71288

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56890

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which version of sql do I have?

1104

how to create a new view in mysql? : Sql dba

982

What are functions in sql?

990

What are different types of functions in sql?

1050

What is sqlcommand?

1068

Explain select statements in sql?

1100

Why use truncate instead of delete?

1064

List and explain the different types of join clauses supported in ansi-standard sql?

1400

What are actual parameters and formal parameters?

1166

What is the usage of nvl function?

1098

How is a PL/SQL code compiled?

1278

what is a trigger in mysql? Define different types of trigger. : Sql dba

1108

What is clause?

1221

When is the explicit cursor used ?

1084

List the various privileges that a user can grant to another user?

1086

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