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 12407

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

5 10694

Delete duplicate records in the emp table.

Oracle,

6 15012

What is magic table?

6 24766

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

IBM,

23 38601

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 20292

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

iFlex,

8 30418

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 17150

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 17325

what are the advantages of package?

iFlex,

7 40354

in materialized view the structure will create immediately or not?

iFlex,

2 9069

How will we see framework of a table?

Accenture,

2 11879

write a query to delete similar records in same table

TCS,

13 25436

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

4 9571

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

TCS,

6 14150

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain how can you save or place your msg in a table?

1074

What are the 3 modes of parameter?

1201

Is nosql relational?

999

How many databases can sql express handle?

1028

What is a loop in sql?

1033

what tools available for managing mysql server? : Sql dba

1127

What is view explain with example?

993

What does the hierarchical profiler does?

1122

How many sql databases can you have on one server?

1150

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1044

How do I save a stored procedure?

1064

What is pls_integer in pl sql?

1153

How do you bind variables in pl sql?

1156

What is %type in sql?

1009

What are different joins used in sql?

1100

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