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 11383

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 16152

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

Oracle,

2 9312

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

3 9124

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

3 8595

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

Sierra Atlantica,

1 4543

Does SQL*Plus contains pl/sql Engine?

TCS,

1 9350

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

Ramco,

2 9193

what is the purpose of update command in oracle?

MBT,

7 11490

What are the advantages of the packages

Oracle,

6 10090

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 19966

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

Oracle,

31 33612

what are the forced views

Hexaware, TCS,

6 23411

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 41935

what is hash join

NCR,

1 12806


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Can we connect to postgresql using sql developer?

463


How do you remove duplicate records from a table?

489


how many values can the set function of mysql take? : Sql dba

510


Explain the difference between sql and mysql.

540


How does index help in query performance?

539






When is a declare statement required?

645


What is the use of prepared statement?

518


what is difference between delete and truncate commands? : Sql dba

550


what is sql? : Sql dba

536


What is the difference between pl and sql?

518


what are wild cards used in database for pattern matching ? : Sql dba

522


How do you remove duplicates without using distinct in sql?

475


What is on delete restrict?

513


Is sql difficult?

720


what are tables and fields? : Sql dba

546