Follow Our FB Page << CircleMedia.in >> 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

IBM,

11 11884

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

Satyam,

14 24925

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

iNautix,

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 ?

IBM,

4 8420

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

RBS,

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?

128


What is a recursive join sql?

150


What are the types of subqueries?

138


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

170


what is 'trigger' in sql? : Sql dba

148






Explain character-manipulation functions?

157


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

186


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

186


Can we group by two columns in sql?

132


How do sql databases work?

147


what are enums used for in mysql? : Sql dba

183


How does index help in query performance?

138


what is check constraint? : Sql dba

148


what is not null constraint? : Sql dba

162


What operators deal with null?

209