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 5387

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

4 10801

which will fire first ? Trigger or Constraint

i2, IBM,

24 51284

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 12380

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

IBM, TCS, UHD,

12 29243

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

iFlex,

4 9748

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

iFlex,

5 11629

how will u find statistics of a database objects?

iFlex,

2 8642

Differences between UNIQUE and DISTINCT in select statements

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

26 135656

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 7903

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 11992

What is pragma exception and how, when, where us

5 15418

What is the usage of NVL?

Infosys, Micro Infotek,

7 21165

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 7732

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a ddl command?

1085

what is datawarehouse? : Sql dba

1015

What is difference between nchar and nvarchar?

1026

What is difference between group by and partition by?

1059

What jobs use sql?

980

How do you run a query?

989

What are system versioned tables?

1027

What are the types of records?

988

How to assign sql query results to pl sql variables?

1078

Can sql function call stored procedure?

1021

Can you do multiple joins in sql?

1050

how would you enter characters as hex numbers? : Sql dba

983

What is crud diagram?

947

What are the features of pl sql?

1067

What are the different ways to optimize a sql query?

946

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