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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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

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