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 13131

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 17650

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

Oracle,

2 10638

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

3 10591

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

3 10154

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

Sierra Atlantica,

1 5485

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10336

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

Ramco,

2 10336

what is the purpose of update command in oracle?

MBT,

7 13883

What are the advantages of the packages

Oracle,

6 12147

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22295

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

Oracle,

31 41787

what are the forced views

Hexaware, TCS,

6 25846

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46531

what is hash join

NCR,

1 13760

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is pl sql variable?

985

Where is sql database stored?

979

How to display Row Number with Records in Oracle SQL Plus?

1047

Mention what is the use of function "module procedure" in pl/sql?

1049

What is the syntax and use of the coalesce function?

1173

What is sql rowcount?

1016

what are different types of collation sensitivity? : Sql dba

1065

Why do we use view in sql?

959

What is the difference between an inner and outer join?

1012

Is there a way to automate sql execution from the command-line, batch job or shell script?

968

What is procedure explain with example?

959

what is heap table? : Sql dba

1105

Give the order of sql select?

1135

How many columns should be in an index?

963

What is primary key sql?

1036

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