Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is checkpoint?

Question Posted / kittu_chintu2005

Answers were Sorted based on User's Feedback



What is checkpoint?..

Answer / 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

What is checkpoint?..

Answer / sreeramch9

Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.

Is This Answer Correct ?    0 Yes 0 No

What is checkpoint?..

Answer / kittu_chintu2005

A checkpoint is a mandatory background process which signals to DBWn

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More DB Administration Interview Questions

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

How would you force a log switch?

4 Answers  

How would you extract DDL of a table without using a GUI tool?

0 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

How to determine the service pack currently installed on SQL Server?

1 Answers  

What is the dataguard background process??

1 Answers   iGate,

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

How do you add a data file to a tablespace?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories