SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

I want to know last five transactions or records from emp table, from now?

Wells Fargo,

11 20941

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 4744

counting the no.of characters occurs in a string by using pl/sql function

TCS,

1 6432

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3i Infotech,

3 8114

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10392

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3i Infotech,

3 8590

function can return value ,procedure also return value through out parameter then what is the difference?

3i Infotech,

3 7977

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16284

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

3i Infotech,

4 11694

why we use nocopy?

Polaris,

2 7570

what is explain plan?, given an example...

Polaris,

3 9712

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

Polaris,

2 7578

What are all the difference between Like and Contains ?

LG Soft,

2 10874

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7530

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

Satyam,

10 13573

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Why is sql important?

1098

what is sp_pkeys? : Transact sql

1149

Is sql a scripting language?

987

How do I know if I have sql express or standard?

1027

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

1006

How do you update sql?

965

Where is all the data on the internet stored?

1007

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1823

Why stored procedure is better than query?

941

how can we repair a mysql table? : Sql dba

974

What is sqlexception in java?

982

What is not null in sql?

1053

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1105

What is update query?

973

Write a query to display the current date in sql?

1018

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