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 10207

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

5 8822

Delete duplicate records in the emp table.

Oracle,

6 12942

What is magic table?

6 22536

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

IBM,

23 29466

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 16112

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

iFlex,

8 27528

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 14849

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 14560

what are the advantages of package?

iFlex,

7 37705

in materialized view the structure will create immediately or not?

iFlex,

2 7942

How will we see framework of a table?

Accenture,

2 10484

write a query to delete similar records in same table

TCS,

13 21196

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

4 7875

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

TCS,

6 11795


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Why query optimization is needed?

505


How do I view tables in mysql?

527


Is it possible to pass parameters to triggers?

557


Can you upgrade sql express to full sql?

502


What steps server process has to take to execute an update statement?

495






How is a process of pl/sql compiled?

584


Which version of sql do I have?

549


how to include comments in sql statements? : Sql dba

531


Why primary key is required?

537


What is multiple partition?

531


What is dynamic query?

528


Is sql better than excel?

507


What is sql keyword?

544


Write a sql select query that only returns each name only once from a table?

550


What is the difference between having clause and where clause?

553