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 different types of database compression introduced in sql server 2008? : sql server DBA
what is grd?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you create a user-defined lock?
How to start SQL Server in minimal configuration mode?
what functionality does oracle provide to secure sensitive information?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the difference between clustered and non-clustered index? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the steps you will take to improve performance of a poor performing query?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Why would you use sql agent? : sql server DBA
