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 12244

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

5 10529

Delete duplicate records in the emp table.

Oracle,

6 14784

What is magic table?

6 24585

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

IBM,

23 37755

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 19845

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

iFlex,

8 30093

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16929

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 17026

what are the advantages of package?

iFlex,

7 40128

in materialized view the structure will create immediately or not?

iFlex,

2 8927

How will we see framework of a table?

Accenture,

2 11752

write a query to delete similar records in same table

TCS,

13 25045

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

4 9420

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

TCS,

6 13896

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is numeric function sql?

1053

What is sp_helptext?

1057

what is the difference between clustered and non clustered index in sql? : Sql dba

1120

What is data type in sql?

950

Do we need to rebuild index after truncate?

1031

What is mutating table error?

1175

how to enter numeric values as hex numbers? : Sql dba

1059

How many indexes can be created on a table in sql?

1044

Does truncate table reset auto increment?

986

How does a trigger work?

1060

How can we avoid duplicating records in a query?

974

How much ram can sql express use?

979

Which one is better sql or oracle?

962

What is snowflake sql?

1068

What is sqlcommand?

1022

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