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 20241

how to sort records in sql?

3 7157

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 22962

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

Tech Mahindra,

5 15587

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 13933

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 22530

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 19943

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

Satyam,

15 41150

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 25746

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

Cap Gemini, iNautix,

24 51662

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 11411

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

RBS,

2 9291

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

2 5314

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

2 5643

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are the properties and different types of sub-queries? : Sql dba

1034

What is sqlservr exe?

977

What is file based approach?

941

Can you do multiple joins in sql?

1052

What are the sql versions?

943

Can 2 queries be executed simultaneously in a distributed database system?

1140

How to get help at the sql prompt?

1113

Where do we use pl sql?

993

Can we rollback delete command?

984

What are the different sql commands?

1073

Does truncate release storage space?

1077

How can you load multi line records? : aql loader

1076

Is sqlite thread safe?

1048

Explain the significance of the & and && operators in pl sql.

1009

how can we know the count/number of elements of an array? : Sql dba

1060

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