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 13133

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 10596

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

3 10156

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

Sierra Atlantica,

1 5493

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10340

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

Ramco,

2 10337

what is the purpose of update command in oracle?

MBT,

7 13885

What are the advantages of the packages

Oracle,

6 12152

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22297

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

Oracle,

31 41802

what are the forced views

Hexaware, TCS,

6 25850

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46542

what is hash join

NCR,

1 13760

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are inbuilt functions in sql?

1064

what is a cursor? : Sql dba

1023

Explain autonomous transaction.

1154

How do you update a value in sql?

1043

How do I edit a trigger in sql developer?

993

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

what is sql server agent? : Sql dba

1103

What is rename in sql?

972

What is the difference between an inner join and an outer join?

1027

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1596

What is clustered index in sql?

1051

How many parts of a pl sql block are optional?

1134

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1153

What is a primary key example?

957

What is orm in sql?

1047

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