SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 54131

How to call DDL statements from pl/sql?

5 27769

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

MBT, Evosys,

4 10873




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

2 10548

what are Dynamic SQL statements?

9 17218

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

TCS,

1 9536

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

4 11293

what is constraining table?

2 10052




How pl/sql source code can be protected?

2 7685

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

TCS,

21 33769

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

2 9462

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

Sail, ICICI, Saama Tech,

7 38966

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 5047

What are the advantages of VIEW?

5 28432

How many LONG columns are allowed in a table?

CTS,

6 17469


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Explain the uses of database trigger.

29


How do you update f as m and m as f from the below table testtable?

20


how would you enter characters as hex numbers? : Sql dba

15


what are the limitations of identity column? : Transact sql

18


What are sql functions? Describe the different types of sql functions?

5






How to create an array in pl/sql?

22


What are the various levels of constraints?

11


Is it possible to create the following trigger: before or after update trigger for each row?

44


what are different types of collation sensitivity? : Sql dba

18


How to set up sql*plus output format in oracle?

21


what are the 'mysql' command line options? : Sql dba

16


what is the difference between union and union all? : Sql dba

13


What is data control language (dcl)?

28


What is the process of copying data from table a to table b?

36


What operating systems are supported by oracle sql developer?

14