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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 12265

Delete the emps whose salaries are lowest sals of their own dept.

5 10544

Delete duplicate records in the emp table.

Oracle,

6 14809

What is magic table?

6 24602

how to check the 3rd max salary from an employee table?

IBM,

23 37855

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

Oracle,

12 19907

what is difference between procedure and function, procedure and trigger?

iFlex,

8 30124

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16957

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

iFlex,

8 17062

what are the advantages of package?

iFlex,

7 40149

in materialized view the structure will create immediately or not?

iFlex,

2 8943

How will we see framework of a table?

Accenture,

2 11765

write a query to delete similar records in same table

TCS,

13 25110

write a query to delete similar records in different tables with same structure

4 9437

write a query to delete similar records in particular fields(columns) in different tables

TCS,

6 13919

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a temp table?

1024

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1040

Explain aggregate functions are available there in sql?

1007

Can pl sql procedure have a return statement?

1030

What is cursor in pl sql?

1116

What is sap sql anywhere?

1077

What are the two parts of design view?

1018

What is numeric function sql?

1059

How do I send sql query results to excel?

1066

What is sql injection owasp?

1060

What are different types of indexes?

1010

what does it mean to have quoted_identifier on? : Sql dba

1145

Is left join same as join?

993

Is pl sql still used?

975

Why do you partition data?

1017

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