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 66491

How to call DDL statements from pl/sql?

5 33499

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

Evosys, MBT,

4 16858

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

3 15003

what are Dynamic SQL statements?

9 26329

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

TCS,

1 15399

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

4 15512

what is constraining table?

2 14205

How pl/sql source code can be protected?

3 11434

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

TCS,

22 51094

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

2 13104

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

ICICI, Saama Tech, Sail,

7 48737

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 7940

What are the advantages of VIEW?

5 34044

How many LONG columns are allowed in a table?

CTS,

6 24413

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many databases can sql express handle?

947

Do stored procedures prevent sql injection?

925

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

969

Is join same as left join?

983

Can unique keys be null?

858

how can we know the number of days between two given dates using mysql? : Sql dba

999

What is a clob in sql?

974

how can I make a script that can be bi-language (supports english, german)? : Sql dba

949

What are sql objects?

1028

Does sqlite need a server?

1004

What is optimistic concurrency control? : Transact sql

948

How does an execution block start and end in pl sql?

907

How do you update a value in sql?

995

Why is a trigger used?

894

What is sql architecture?

996

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