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 5391

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

4 10802

which will fire first ? Trigger or Constraint

i2, IBM,

24 51288

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 12381

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

IBM, TCS, UHD,

12 29247

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

iFlex,

4 9751

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

iFlex,

5 11631

how will u find statistics of a database objects?

iFlex,

2 8645

Differences between UNIQUE and DISTINCT in select statements

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

26 135667

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 7904

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 11993

What is pragma exception and how, when, where us

5 15419

What is the usage of NVL?

Infosys, Micro Infotek,

7 21167

scope of exception handling in plsql

Wipro,

4 13109

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 7734

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is difference between inner join and self join?

1084

What is sql keyword?

1001

How exception handling is done in advance pl/sql?

981

What does count (*) mean?

928

Name some usages of database trigger?

1019

Is a foreign key always unique?

942

What is the source code of a program?

1069

What is union?

1169

How to download oracle sql developer?

1106

What is sqlcontext?

1083

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1164

describe transaction-safe table types in mysql : sql dba

1006

What is date functions?

1028

How to add new employee details in an employee_details table with the following details

1091

How to run pl sql program in mysql?

1020

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