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 13132

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 10592

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 10337

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 13884

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 41791

what are the forced views

Hexaware, TCS,

6 25847

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46534

what is hash join

NCR,

1 13760

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is aggregate function in sql?

1036

How do I tune a sql query?

974

How many rows can sqlite handle?

1112

Is delete faster than truncate?

1002

what is 'mysqldump'? : Sql dba

1108

What is numeric function sql?

1059

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2571

how to calculate expressions with sql statements? : Sql dba

1033

What is cursor and its types?

1071

How do I restart sql?

972

How to pronounce postgresql?

1057

what is the difference between blob and text? : Sql dba

1019

Is merge a dml statement?

978

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3567

What is pl sql block in dbms?

1002

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