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 20474

how to sort records in sql?

3 7281

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 23085

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

Tech Mahindra,

5 15773

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 14089

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 22782

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 20306

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

Satyam,

15 41506

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

iNautix,

2 13426

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25926

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

Cap Gemini, iNautix,

24 52252

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 11567

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

RBS,

2 9367

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

2 5405

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

2 5725

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is a materialized view? : Sql dba

1126

What is the difference between sql, mysql and sql server?

1171

Is mariadb a nosql database?

1098

What is the use of double ampersand (&&) in sql queries? Give an example

1187

Write a sql query to find the names of employees that begin with ‘a’?

1055

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1028

What is constant in pl sql?

1059

what is innodb? : Sql dba

1163

What can I use instead of union in sql?

1020

What is a heap in sql?

1137

Can you inner join the same table?

1036

What is pl sql package?

1071

Explain clause in sql?

1070

What is hibernate and its relation to sql?

1166

Why schema is used in sql?

1088

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