Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 56098

How to call DDL statements from pl/sql?

5 28778

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

Evosys, MBT,

4 11953

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

2 11250

what are Dynamic SQL statements?

9 18492

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

TCS,

1 10125

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

4 11837

what is constraining table?

2 10762

How pl/sql source code can be protected?

2 8164

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

TCS,

21 36230

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

2 9980

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

ICICI, Saama Tech, Sail,

7 40840

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 5410

What are the advantages of VIEW?

5 29489

How many LONG columns are allowed in a table?

CTS,

6 18666


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

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 ?

37


Explain ttitle and btitle.

180


How to run sql commands in sql*plus?

159


what is the use of double ampersand (&&) in sql queries?

159


Why is nosql good?

117






How to read/write files from pl/sql?

148


What is write ahead logging in sql server?

98


What is an inner join sql?

107


Can we use ddl commands in pl sql?

115


What are %type and %rowtype for?

180


What is sql query optimization?

103


What is foreign key in sql with example?

108


what is a constraint? Tell me about its various levels. : Sql dba

138


What are packages in pl sql and also explain its advantages?

145


what is collation? : Sql dba

146