SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

can we call a procedure from a function?

Mind Tree,

9 20237

how to sort records in sql?

3 7157

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 22959

can we delete the trigger in a view? if yes why if not why?

Tech Mahindra,

5 15584

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 13931

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 22529

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

IBM,

12 19942

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

Satyam,

15 41142

what will be the output: select 1 from emp union all select 2 from emp;

iNautix,

2 13329

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25744

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

Cap Gemini, iNautix,

24 51657

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

IBM,

4 11410

if a table is getting updated what happens if a function is called from sql query?

RBS,

2 9290

how can create data base link for tow servers (scott schema) give examples plz

2 5313

using comand prompt how can import table data and table space with example

2 5642

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the process of debugging?

1069

How do you rank data in sql?

1003

How do you drop a trigger?

987

What is graph sql?

987

Explain two easy sql optimizations.

1008

What are the different types of dbmss?

1013

What is procedure function?

1055

How to disable a trigger name update_salary?

1266

What is autocommit sql?

992

What is use of package in pl sql?

1013

When you have to use a default "rollback to" savepoint of plvlog?

1191

What is the life of an sql statement?

1024

What are the disadvantages of file system?

1267

what is innodb? : Sql dba

1102

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

965

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