Answer Posted / sudarsan
check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
what do you understand by fine-grained auditing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the different types of indexes available in sql server? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What is a system database and what is a user database? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
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
internal architecture
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What is a correlated sub-query? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Explain materialized views and how they are used.