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 12874

what is switch column,colums cost in oracle?

Metric Stream,

3611

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

Metric Stream,

1 9240

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 8746

display records from 5 to 9 using rowid or rownum

Agile Software,

5 15842

How to update salary of employees department wise?

6 14973

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

2 6503

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 10564

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

3 7232

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

2190

How to get second highest salary from a table

3 7032

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

2 8770

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

1 5730

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

Karrox,

2 7617

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 6106

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is clustered index in sql?

1011

How do I run a sql query in pgadmin 4?

912

Which certification is best for sql?

946

What is natural join in sql?

927

What is sql injection vulnerability?

880

How many joins in sql?

957

Is left join inner or outer?

972

How do I find duplicates in a single column in sql?

958

What is the difference between clustered and non-clustered indexes?

1034

Which type of cursor is used to execute the dml statement?

907

What is basic structure of pl sql?

1003

What is the limitation on the block size of pl/sql?

946

what are myisam tables? : Sql dba

967

In a distributed database system, can we execute two queries simultaneously?

1010

What is t sql used for?

979

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