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 67348

How to call DDL statements from pl/sql?

5 33867

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

Evosys, MBT,

4 17241

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

3 15319

what are Dynamic SQL statements?

9 26921

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

TCS,

1 15612

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

4 15925

what is constraining table?

2 14442

How pl/sql source code can be protected?

3 11762

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

TCS,

22 52630

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

2 13367

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

ICICI, Saama Tech, Sail,

7 49227

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 8249

What are the advantages of VIEW?

5 34426

How many LONG columns are allowed in a table?

CTS,

6 24944

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is an example of translating a date into julian format?

1199

how to return query output in html format? : Sql dba

1111

Can we commit inside a trigger?

1043

Does oracle roll back the transaction on an error?

1065

Why is sql better than hql?

1060

What is record variable?

1030

What is %type in sql?

1005

How much does sql certification cost?

1132

Does sql use python?

1088

How do rank () and dense_rank () differ?

1102

Does access use sql?

1089

Why is pl sql needed?

994

Can sql function call stored procedure?

1067

Can two tables have same primary key?

1018

Mention what does the hierarchical profiler does?

1131

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