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 5465

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

4 10952

which will fire first ? Trigger or Constraint

i2, IBM,

24 51957

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 12491

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

IBM, TCS, UHD,

12 29626

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

iFlex,

4 9919

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

iFlex,

5 11819

how will u find statistics of a database objects?

iFlex,

2 8753

Differences between UNIQUE and DISTINCT in select statements

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

26 136418

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 8016

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 12277

What is pragma exception and how, when, where us

5 15606

What is the usage of NVL?

Infosys, Micro Infotek,

7 21397

scope of exception handling in plsql

Wipro,

4 13265

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 7855

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explian rowid, rownum? What are the psoducolumns we have?

1045

What is data types in sql?

1070

Is postgresql a server?

1107

Is it possible to sort a column using a column alias?

1095

What is a loop in sql?

1033

What is the usage of the distinct keyword?

1271

What language is oracle sql developer?

1069

How do you drop a trigger?

1035

What is nvl?

1108

What is query syntax?

1017

Explain select statements in sql?

1104

How many tables can you join in sql?

1005

Write a sql query to find the names of employees that begin with ‘a’?

1055

how to present a past time in hours, minutes and seconds? : Sql dba

1066

What are the qualities of 2nf?

1094

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