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 66227

How to call DDL statements from pl/sql?

5 33349

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

Evosys, MBT,

4 16748

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

3 14918

what are Dynamic SQL statements?

9 26146

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

TCS,

1 15344

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

4 15384

what is constraining table?

2 14127

How pl/sql source code can be protected?

3 11356

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

TCS,

22 50740

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

2 13046

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

ICICI, Saama Tech, Sail,

7 48596

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 7875

What are the advantages of VIEW?

5 33938

How many LONG columns are allowed in a table?

CTS,

6 24286

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is auto increment? : Sql dba

942

What is the use of & in pl sql?

968

Why trigger is used in sql?

897

how is myisam table stored? : Sql dba

983

What type of database is sql?

961

What is %type in sql?

896

What are the types of variable use in pl sql?

985

What are some predefined exceptions in pl/sql?

1023

Can we create a trigger on view?

823

Explain isolation levels. : Transact sql

993

What do you mean by stored procedures? How do we use it?

908

define sql delete statement ? : Sql dba

952

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3908

what is the difference between a web-garden and a web-farm? : Sql dba

988

What is the sql case statement?

934

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