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 12267

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

5 10545

Delete duplicate records in the emp table.

Oracle,

6 14810

What is magic table?

6 24603

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

IBM,

23 37863

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 19911

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

iFlex,

8 30124

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16958

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 17068

what are the advantages of package?

iFlex,

7 40152

in materialized view the structure will create immediately or not?

iFlex,

2 8944

How will we see framework of a table?

Accenture,

2 11766

write a query to delete similar records in same table

TCS,

13 25118

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

4 9439

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 are the two characteristics of a primary key?

975

Can a varchar be a primary key?

1009

How do I trace sql profiler?

978

What are different functions in sql?

946

how to use case expression? : Sql dba

1024

what are the different tables present in mysql? : Sql dba

984

What are the various restrictions imposed on view in terms of dml?

965

Is pl sql and postgresql same?

1132

what are the join types in tsql? : Transact sql

1064

what are date and time functions in mysql? : Sql dba

979

Is grant a ddl statement?

896

How many types of normalization are there?

963

How to use distinct and count in sql query? Explain

1023

What does the hierarchical profiler does?

1058

Why are indexes and views important to an organization?

956

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