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 20980

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 4754

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

TCS,

1 6437

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 8123

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10410

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

3i Infotech,

3 8606

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

3i Infotech,

3 8000

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16297

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

3i Infotech,

4 11724

why we use nocopy?

Polaris,

2 7575

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

Polaris,

3 9742

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 7584

What are all the difference between Like and Contains ?

LG Soft,

2 10886

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7552

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 13602

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I add a primary key to a table?

1042

What is optimistic concurrency control? : Transact sql

984

Why do you partition data?

1021

what are the differences between require and include, include_once and require_once? : Sql dba

1022

Why do we need pl sql?

980

What is the difference between left and left outer join?

944

Are sql database names case sensitive?

1006

What is attribute indicator in pl sql?

1015

Are pl sql variables case sensitive?

1050

What are the types of keys?

996

Does execute immediate commit?

1221

What is clustered and nonclustered index in sql?

944

What is sql entity?

1107

Can we insert data into materialized view?

945

how to use case expression? : Sql dba

1027

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