Oracle Facts

177)Whats the difference between a scalar sub Query and an Inline View? A subquery in the FROM clause is called an inline view and this su...

151)What is meant by Row Migration? We will migrate a row when an update to that row would cause it to not fit on the block anymore (with ...

146)What are the parameters which influence the sorting of Query Results? SORT_AREA_SIZE Temporary Tablespace and its size 147)Why and Whe...

123)What is the basic Structure of a PLSQL Block? Declare Begin Exception End 124)What are the different types of PLSQL Objects that you h...

101)Will Context Switching hinder the performance of an application? SQL statements are called from PL/SQL in a loop, so the execution wil...

82)What is meant by External Tables in Oracle? The external tables feature is a complement to existing SQL*Loader functionality. It enable...

75)What is the difference that you find with a Locally managed and a Dictionary managed Tablespace? Benefits of LMTs Below are the key ben...