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 20992

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 4755

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

TCS,

1 6439

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 8131

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10414

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

3i Infotech,

3 8616

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

3i Infotech,

3 8008

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16301

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

3i Infotech,

4 11730

why we use nocopy?

Polaris,

2 7580

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

Polaris,

3 9750

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 7586

What are all the difference between Like and Contains ?

LG Soft,

2 10890

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7559

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 13611

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a loop in sql?

988

What is an index in sql with example?

976

Does sql full backup truncate logs?

1020

Why select is used in sql?

1023

Can we use pl sql in mysql?

1015

How do I count duplicates in sql?

1113

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

960

what are string data types? : Sql dba

1047

What does (*) mean in sql?

955

What does the file extension accdb stand for?

972

Is vs as in pl sql?

991

What is sequence in sql?

1026

where are cookies actually stored on the hard disk? : Sql dba

1030

How many tables can a sql database have?

979

What is triggering circuit?

1070

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