Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

can we call a procedure from a function?

Mind Tree,

9 16486

how to sort records in sql?

3 5612

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 20179

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

Tech Mahindra,

5 13062

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 11866

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 19139

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


11 13596

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


14 31403

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


2 11866

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 23265

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

Cap Gemini, iNautix,

23 41445

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 ?


4 9417

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


2 7766

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

2 3984

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

2 4254

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql comments?


Is sql a oracle?


What is the purpose of a sql?


What is procedure in pl sql?


What is nvarchar in sql?


How do I write a sql query in pgadmin 4?


How can a pl sql block be executed?


What is data profiling in sql?


Why is nosql good?


Is pl sql better than sql?


How bulk collect improves performance?


Does truncate require commit?


What is a column in a table?


Can dml statements be used in pl/sql?


What is a pl/sql block?