SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 66416

How to call DDL statements from pl/sql?

5 33444

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 16827

How to maintain the history of code changes of pl/sql?

3 14977

what are Dynamic SQL statements?

9 26277

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 15387

What is pl/sql and what is it used for?

4 15462

what is constraining table?

2 14180

How pl/sql source code can be protected?

3 11406

What is the result, when NULL is compared with NULL?

TCS,

22 50961

What can be a size of a pl/sql block? Is there any limit?

2 13084

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 48688

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 7923

What are the advantages of VIEW?

5 34010

How many LONG columns are allowed in a table?

CTS,

6 24366

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are % type and % rowtype?

977

What is pl/sql table? Why it is used?

988

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

what is 'trigger' in sql? : Sql dba

1009

Explain the difference between triggers and constraints?

919

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1957

how do you know the version of your mysql server? : Sql dba

935

When you have to use a default "rollback to" savepoint of plvlog?

1123

What is the difference between partition and index?

921

Explain what is sql?

1055

Is there any restriction on the use of union in embedded sql?

1099

what are the differences between char and varchar? : Sql dba

1000

What can sql server reporting services do?

1052

How do I remove sql developer from windows 10?

1011

How is a PL/SQL code compiled?

1170

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