Answers were Sorted based on User's Feedback
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|
Answer / sawant
Dictionary cache is information about the databse objects
stored in a data dictionary table.
|Is This Answer Correct ?||0 Yes||0 No|
What is a data segment ?
What is bulk collect in oracle?
What do you mean by merge in oracle and how can we merge two tables?
What are operators in oracle?
How much memory your 10g xe server is using?
when do u go for hash partitioning?
What is the purpose of save points in oracle database?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how to unbreak sequence numbers during intereptions
What is the quickest way to export a table to a flat file?
Please explain oracle data types with examples?
How to use group functions in the select clause using oracle?