Answer Posted / chandra mohan
LIBRARY CACHE,DATA DICTIONARY CACHE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are the benefits of flashback feature?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the importance of a recovery model? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Where would you look for errors from the database engine?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Query processing is slow(eg select query)how will u solve that
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How would you best determine why your MVIEW couldn't FAST REFRESH?
Explain materialized views and how they are used.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
