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 180395

What is the difference between anonymous block and named blocks?

3 10613

what is inline view?

15 41891

what is the difference between implicit conversions and explicit conversions?

2 9207

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 14366

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 8926

What is Referential Integrity?

3 8025

can we update a view which is created from two tables

11 34017

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 15882

Can u create a primary key with out unique index.

8 14829

what are the demerits of sql?

1 5337

what is the difference between binary_integer and pls_integer

TCS,

2 32347

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

Microsoft,

2564

What cursor type do you use to retrieve multiple recordsets?

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

17 70666

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 56611

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many types of tables are there?

947

explain the advantages and disadvantages of stored procedure? : Sql dba

1003

What is pl sql block in dbms?

997

What does the argument [or replace] do?

1073

what is bcp? When does it used? : Sql dba

982

What is dialect in sql?

939

What is plpgsql language?

1055

Why do we use cursors?

984

Why do we use sqlite?

964

What are the possible values for the boolean data field?

955

How to run sql commands in sql*plus?

1171

What is an intersect?

1096

What found sql?

938

What is rownum in sql?

1034

What is pl sql block structure?

1034

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