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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 12978

what is switch column,colums cost in oracle?

Metric Stream,

3667

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

Metric Stream,

1 9305

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

TCS,

3 8866

display records from 5 to 9 using rowid or rownum

Agile Software,

5 16005

How to update salary of employees department wise?

6 15165

what are the methods using performance tunning in sql and pl/sql

2 6616

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

IBM, Loginworks, OFSS,

2 10642

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 7345

How do you use collections in procedure to return the resultset?

2236

How to get second highest salary from a table

3 7157

What is the maximum number of triggers,can apply to a single table?

2 8861

What packages(if any) has oracle provided for use by developers?

1 5801

25.67,-1 Trunc = 20 Round= 30 HOW????

Karrox,

2 7711

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

Oracle,

2 6205

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the insert into statements in sql?

1000

What is informix sql?

972

differentiate between float and double. : Sql dba

1048

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1121

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

963

Does sap use sql?

977

what is dbms? : Sql dba

985

What does truncate mean in sql?

1017

How do I partition a table in sql?

1121

What is a field in a database?

1059

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3564

What is a record in pl/sql?

1137

What is a unique key?

1047

what is 'mysqlshow'? : Sql dba

1018

How to call a javascript function from pl sql?

1129

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