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 21305

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 4818

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

TCS,

1 6527

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 8235

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10537

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

3i Infotech,

3 8746

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

3i Infotech,

3 8124

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16387

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

3i Infotech,

4 11855

why we use nocopy?

Polaris,

2 7693

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

Polaris,

3 9894

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 7665

What are all the difference between Like and Contains ?

LG Soft,

2 11002

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7681

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 13898

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are the types of subquery? : Sql dba

1156

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1077

Which function is used to return remainder in a division operator in sql?

1196

explain advantages of myisam over innodb? : Sql dba

1111

What is procedure function?

1122

What is a crud api?

991

What is pl sql collection?

1015

what is subquery? : Sql dba

1187

Can a key be both primary and foreign?

1053

What does trigger mean in slang?

1120

What is the purpose of a sql?

1041

how to shutdown mysql server? : Sql dba

1144

How to disable a trigger name update_salary?

1310

How do I count duplicates in sql?

1175

What is a stored procedure in sql with example?

1199

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