What is dictionary cache ?

Question Posted / sawant

Answers were Sorted based on User's Feedback

What is dictionary cache ?..

Answer / cinnaraja

Once the database server has accessed the table from the
datafile , it places that information in the data-dictionary
cache in shared memory.

Is This Answer Correct ?

1 Yes

0 No

What is dictionary cache ?..

Answer / sawant

Dictionary cache is information about the databse objects
stored in a data dictionary table.

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How to Select second Maximum salary in a Table ?

How is it different from a normal table?

What are the composite date types in oracle?

Explain the concept of the DUAL table.

Query to get max and second max in oracle in one query ?

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

What are the factors causing the reparsing of SQL statements in SGA?

What is hash cluster in oracle?

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

What is a sub query? Describe its types?

Explain a data segment?

For more Oracle General Interview Questions Click Here