SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 5375

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 10791

which will fire first ? Trigger or Constraint

i2, IBM,

24 51171

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

eBay,

3 12360

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

IBM, TCS, UHD,

12 29216

if we give update table_name set column_name= default. what will happen?

iFlex,

4 9709

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

iFlex,

5 11598

how will u find statistics of a database objects?

iFlex,

2 8630

Differences between UNIQUE and DISTINCT in select statements

ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

26 135557

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 7893

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 11969

What is pragma exception and how, when, where us

5 15395

What is the usage of NVL?

Infosys, Micro Infotek,

7 21131

scope of exception handling in plsql

Wipro,

4 13093

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 7719

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a function in oracle pl sql?

1035

How to start oracle sql developer?

1030

What is a delimiter in sas?

1049

What is cursor status?

1184

What is pivot table in sql?

1097

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1009

What are the advantages of sql?

1053

what is blob? : Sql dba

1141

What are the main features of cursor?

1071

What is rtm stands for?

1093

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1434

What are stored procedures used for?

997

Can a varchar be a primary key?

1007

What is the difference between rename and alias?

1338

What is oracle sql called?

922

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