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 66948

How to call DDL statements from pl/sql?

5 33729

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

Evosys, MBT,

4 17081

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

3 15176

what are Dynamic SQL statements?

9 26696

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

TCS,

1 15526

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

4 15761

what is constraining table?

2 14329

How pl/sql source code can be protected?

3 11622

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

TCS,

22 51885

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

2 13255

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

ICICI, Saama Tech, Sail,

7 48996

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 8119

What are the advantages of VIEW?

5 34257

How many LONG columns are allowed in a table?

CTS,

6 24717

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to display the records between two range in Oracle SQL Plus?

1146

What is data control language?

990

What does seeding a database mean?

964

Explain clause in sql?

1029

How to convert comma separated string to array in pl/sql?

1184

What is db journal file?

1064

How can I get the number of records affected by a stored procedure?

1065

What is the difference between partitioning and sharding?

1008

what is sql in mysql? : Sql dba

1192

what is the bond code in materialized view?

3002

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1059

Explain raise_application_error.

1095

What are the two different parts of the pl/sql packages?

1087

What is assignment operator in pl sql?

1035

Explain the savepoint statement.

1096

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