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 12934

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 17425

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

Oracle,

2 10503

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

3 10427

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

3 9963

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

Sierra Atlantica,

1 5371

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10226

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

Ramco,

2 10168

what is the purpose of update command in oracle?

MBT,

7 13565

What are the advantages of the packages

Oracle,

6 11891

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 21988

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

Oracle,

31 40599

what are the forced views

Hexaware, TCS,

6 25519

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 45856

what is hash join

NCR,

1 13652

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the basic form of sql query?

879

how to rename an existing column in a table? : Sql dba

959

What is t sql in sql server?

1001

What are the steps for performance tuning.

1268

What is the mutating table and constraining table?

966

what is the difference between join and union? : Sql dba

1027

What is the purpose of my sql?

899

How to download oracle sql developer?

1056

Are subqueries better than joins?

917

What is the difference between a query and a report?

900

Explain lock escalation? : Transact sql

1142

Is null operator in sql?

978

What can I use instead of union in sql?

903

Why do we use joins in sql?

908

Is t sql a programming language?

1005

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