Answers were Sorted based on User's Feedback
Answer / sawant
The data dictionary cache is stored in an area in SGA called
the Shared SQL Pool. This will allow sharing of parsed
SQL statements among concurrent users.
|Is This Answer Correct ?||2 Yes||1 No|
Answer / rashid ansari
shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool
|Is This Answer Correct ?||1 Yes||2 No|
How does Oracle guarantee data integrity of data changes?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
How to define a variable to match a table column data type?
What is oracle join syntax?
what is difference between cartesian join & cross join even they give same result?
How to download oracle database 10g xe?
What the is the diff between local index and global index. give some example.
What is the difference between sharding and replication?
Please explain drop constraint oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is a view and how is it different from a table?
What are the uses of linked server and explain it in detail?