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 17505

how to sort records in sql?

 3 5999

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 21430

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

Tech Mahindra,

5 13733

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 12438

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 20420

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,

12 14880

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

Satyam,

15 36557

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

iNautix,

2 12286

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 23986

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

Cap Gemini, iNautix,

24 44516

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 9965

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

RBS,

2 8184

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

 2 4359

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

 2 4582

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Does sql support programming?

543

How do you optimize a stored procedure in sql?

494

Why coalesce is used in sql?

466

how can we find the number of rows in a table using mysql? : Sql dba

575

Difference between table function and pipelined function?

574




How we can update the view?

593

Is drop table faster than truncate?

543

Is not equal in sql?

557

When are we going to use truncate and delete?

545

what is offset-fetch filter in tsql? : Transact sql

528

what is the difference between a web-garden and a web-farm? : Sql dba

547

What are the different types of joins in sql?

574

What is a schema sql?

520

Write a sql select query that only returns each name only once from a table?

555

What is normalization in sql?

517

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