SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 62000

How to call DDL statements from pl/sql?

5 31307

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

Evosys, MBT,

4 14748

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

3 13421

what are Dynamic SQL statements?

9 23126

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

TCS,

1 13972

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

4 13557

what is constraining table?

2 12717

How pl/sql source code can be protected?

3 9748

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

TCS,

22 45152

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

2 11655

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

ICICI, Saama Tech, Sail,

7 45735

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 6578

What are the advantages of VIEW?

5 31898

How many LONG columns are allowed in a table?

CTS,

6 22000


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is an invalid partition table?

550


Explain the working of foreign key?

532


What are functions in sql?

497


Why do we create views in sql?

543


What is a variable in sql?

503






Which is faster count (*) or count 1?

525


Why do we use sql constraints? Which constraints we can use while creating database in sql?

535


How do I order by ascending in sql?

523


Why functions are used in sql?

503


What is scalar data type in pl sql?

542


how to concatenate two character strings? : Sql dba

539


Write a sql query to convert all character to uppercase after hypen.

949


How do I remove all records from a table?

555


How does pl sql work?

513


How do you create an update query?

507