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 20199

how to sort records in sql?

3 7150

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 22937

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

Tech Mahindra,

5 15562

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 13906

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 22508

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 19918

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

Satyam,

15 41114

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

iNautix,

2 13320

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25729

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

Cap Gemini, iNautix,

24 51552

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 11384

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

RBS,

2 9282

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

2 5302

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

2 5635

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is dense_rank in sql?

976

What is dcl in sql?

955

what is transaction? : Sql dba

1003

How do you modify a column in sql?

988

Does sql backup shrink transaction log?

975

What is column?

983

how to do backup entire database? : Transact sql

1137

What is not equal in sql?

1114

What are the types of dbms?

968

Why coalesce is used in sql?

1004

What does bitemporal mean?

1060

How to revise and re-run the last sql command?

1160

Can we update views in sql?

936

How do you select unique values in sql?

997

What is foreign key and example?

927

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