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 180555

What is the difference between anonymous block and named blocks?

3 10635

what is inline view?

15 41972

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 14411

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 8935

What is Referential Integrity?

3 8045

can we update a view which is created from two tables

11 34071

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 14876

what are the demerits of sql?

1 5348

what is the difference between binary_integer and pls_integer

TCS,

2 32370

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 70779

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56658

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a variable in sql?

1001

Is ms sql is free?

1020

describe transaction-safe table types in mysql : sql dba

1006

How do I partition a table in sql?

1130

What are the different schemas objects that can be created using pl/sql?

1028

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

What are sql*plus environment variables?

1094

When is the update_statistics command used?

1116

What is sql in java?

1087

Enlist the characteristics of pl/sql?

1801

What is the location of pre_defined_functions.

1166

what is a relationship and what are they? : Sql dba

1101

What are user defined functions?

1017

what is 'mysqlcheck'? : Sql dba

1014

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1059

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