SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

TCS,

4 13111

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

TCS,

3 17619

how instead of triger is helpful for mutating tables errors handlling ?

Oracle,

2 10620

How to execute OS(operating system) command from pl/sql?

3 10567

What is the best strategy to use COMMIT in a pl/sql loop?

3 10129

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

Sierra Atlantica,

1 5476

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10325

How to find string or key value using pl/sql code?

Ramco,

2 10319

what is the purpose of update command in oracle?

MBT,

7 13847

What are the advantages of the packages

Oracle,

6 12124

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22251

how to retrieve the top 3 salaries of the table using rownum

Oracle,

31 41676

what are the forced views

Hexaware, TCS,

6 25798

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46460

what is hash join

NCR,

1 13747

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do you update a table in sql?

978

What is a unique key?

1045

How do I install microsoft sql?

1041

What is a trigger in sql?

1198

What is the usage of the distinct keyword?

1213

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1262

how to check myisam tables for errors? : Sql dba

1315

Can a composite key be null?

970

Explain normalization and what are the advantages of it?

947

What is the sql*loader? : aql loader

1044

Can we create table in function?

957

What is hibernate and its relation to sql?

1115

What are the different dcl commands in sql?

1135

what is user defined functions? : Sql dba

1022

What is the advantage of index in sql?

960

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