1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 17793

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 3583

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

TCS,

1 5512

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 6722

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 9205

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

3i Infotech,

3 7146

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

3i Infotech,

3 6593

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 15235

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

3i Infotech,

4 9970

why we use nocopy?

Polaris,

2 6560

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

Polaris,

3 8253

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 6541

What are all the difference between Like and Contains ?

LG Soft,

2 9802

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 6347

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 10983

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the qualities of 2nf?

541

What are all the different normalizations?

583

Which version of sql do I have?

558

What is normalization in a database?

610

What are sql objects?

538




What are types of exception?

530

What is an inner join sql?

542

Which normal form is best?

511

How many tables can you join in sql?

522

How do you know if a relationship is 2nf?

516

How do you explain an index number?

531

what are enums used for in mysql? : Sql dba

605

how do you know if your mysql server is alive? : Sql dba

592

What is gpt format?

499

List and explain the different types of join clauses supported in ansi-standard sql?

809

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