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 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

IBM,

11 13596

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

Satyam,

14 31403

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

iNautix,

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 ?

IBM,

4 9417

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

RBS,

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?

508


Is sql a oracle?

372


What is the purpose of a sql?

373


What is procedure in pl sql?

376


What is nvarchar in sql?

365






How do I write a sql query in pgadmin 4?

407


How can a pl sql block be executed?

371


What is data profiling in sql?

363


Why is nosql good?

388


Is pl sql better than sql?

382


How bulk collect improves performance?

381


Does truncate require commit?

379


What is a column in a table?

375


Can dml statements be used in pl/sql?

425


What is a pl/sql block?

435