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 14776

how to sort records in sql?

3 4931

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 17516

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

Tech Mahindra,

5 11860

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 10730

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 16877

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 11884

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


14 24925

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


2 11292

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 21815

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

Cap Gemini, iNautix,

23 36928

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 8420

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


2 7180

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

2 3536

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

2 3802

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is difference between sql and excel?


What is a recursive join sql?


What are the types of subqueries?


How to move files from one directory to another in pl sql?


what is 'trigger' in sql? : Sql dba


Explain character-manipulation functions?


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


How to add new employee details in an employee_details table with the following details


Can we group by two columns in sql?


How do sql databases work?


what are enums used for in mysql? : Sql dba


How does index help in query performance?


what is check constraint? : Sql dba


what is not null constraint? : Sql dba


What operators deal with null?