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 12270

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

5 10547

Delete duplicate records in the emp table.

Oracle,

6 14810

What is magic table?

6 24607

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

IBM,

23 37873

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 19914

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

iFlex,

8 30128

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16961

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 17078

what are the advantages of package?

iFlex,

7 40157

in materialized view the structure will create immediately or not?

iFlex,

2 8946

How will we see framework of a table?

Accenture,

2 11767

write a query to delete similar records in same table

TCS,

13 25126

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

4 9441

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

TCS,

6 13921

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is collation? : Sql dba

1155

Which join condition can be specified using on clause?

952

How do rank () and dense_rank () differ?

1046

When are we going to use truncate and delete?

989

List different type of expressions with the example.

935

who introduced sql?

1022

What is normalization sql?

1060

What are the sql commands?

1181

What is the use of count (*) in sql?

1054

What does pl sql stand for?

1117

what is index? : Sql dba

1006

what are the advantages of using stored procedures? : Sql dba

1105

What type of join is sql join?

982

How many parts of a pl sql block are optional?

1134

What is the use of sqldataadapter?

975

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