Answer Posted / chandra mohan
LIBRARY CACHE,DATA DICTIONARY CACHE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Can you redefine a table online?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you communicate with operating system files from oracle?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is fill factor? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
what is grd?
What is the difference between dropping a database and taking a database offline? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by flashback feature of oracle?
what are the benefits of flashback feature?