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 13264

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 17792

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

Oracle,

2 10739

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

3 10722

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

3 10279

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

Sierra Atlantica,

1 5598

Does SQL*Plus contains pl/sql Engine?

TCS,

1 10418

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

Ramco,

2 10443

what is the purpose of update command in oracle?

MBT,

7 14080

What are the advantages of the packages

Oracle,

6 12311

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22494

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

Oracle,

31 42695

what are the forced views

Hexaware, TCS,

6 26049

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 47018

what is hash join

NCR,

1 13836

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql database free?

1020

Why is %isopen always false for an implicit cursor?

1149

What is where clause in sql?

1083

How do you rename a table in sql?

1178

Mention what are the benefits of pl/sql packages?

1151

Enlist the data types that can be used in pl/sql?

1106

How to select unique records from a table?

1105

differentiate between float and double. : Sql dba

1104

What is composite data type in pl sql?

1164

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1235

What is the difference between sql, mysql and sql server?

1169

What are the main features of cursor?

1108

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1008

What is materialized view. What are different methods of refresh?

1437

What is the syntax and use of the coalesce function?

1206

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