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 180547

What is the difference between anonymous block and named blocks?

3 10634

what is inline view?

15 41956

what is the difference between implicit conversions and explicit conversions?

2 9225

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 14404

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 34066

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 15922

Can u create a primary key with out unique index.

8 14869

what are the demerits of sql?

1 5346

what is the difference between binary_integer and pls_integer

TCS,

2 32366

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 70750

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56650

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the purpose of using pl/sql?

1144

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1065

When is a declare statement required?

1138

What is vector point function?

1052

What are the query optimization techniques?

934

What is partition in sql query?

998

What is dbo in sql?

962

Why do you partition data?

1017

Which sql most popular?

988

Cite the differences between execution of triggers and stored procedures?

1077

how to enter binary numbers in sql statements? : Sql dba

972

What is the use of sqldataadapter?

975

What can sql server reporting services do?

1109

What is the difference between local variables and global variables?

1125

Differentiate between sga and pga.

1161

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