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 66866

How to call DDL statements from pl/sql?

5 33690

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

Evosys, MBT,

4 17040

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

3 15152

what are Dynamic SQL statements?

9 26627

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

TCS,

1 15500

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

4 15731

what is constraining table?

2 14311

How pl/sql source code can be protected?

3 11595

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

TCS,

22 51726

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

2 13214

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

ICICI, Saama Tech, Sail,

7 48958

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 8094

What are the advantages of VIEW?

5 34219

How many LONG columns are allowed in a table?

CTS,

6 24651

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is benefit of creating memory optimized table?

965

How do you use a while loop in pl sql?

1001

how to create a table index in mysql? : Sql dba

1050

What is an exception in pl/sql?

1072

What does (*) mean in sql?

945

What is the starting oracle error number? What is meant by forward declaration in functions?

983

Does pl/sql support create command?

1097

How do I make my sql query run faster?

934

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1174

Explain the difference in execution of triggers and stored procedures?

1012

What is sqlca in powerbuilder?

1000

What is rename command in sql?

1020

What is the use of index in hive?

1000

What is replication id?

929

what are wild cards used in database for pattern matching ? : Sql dba

1132

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