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 17638

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 3549

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

TCS,

1 5482

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 6659

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 9168

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

3i Infotech,

3 7087

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

3i Infotech,

3 6518

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 15194

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

3i Infotech,

4 9924

why we use nocopy?

Polaris,

2 6502

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

Polaris,

3 8199

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 6498

What are all the difference between Like and Contains ?

LG Soft,

2 9768

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 6309

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 10854


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the difference in execution of triggers and stored procedures?

545


Is sql dba a good career? : SQL DBA

513


Is oracle sql free?

514


How do we use distinct statement? What is its use?

531


Why stored procedure is better than query?

487






Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

513


What is the current version of sql?

512


What is varchar example?

547


What is an alias command?

549


what are the advantages of sql ? : Sql dba

520


How many types of keys are there in sql?

531


What is dml with example?

490


What is the requirement of self-join?

516


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

560


What is sql*loader?

557