What is checkpoint?

Question Posted / kittu_chintu2005

3 Answers
5919 Views
Accenture, I also Faced
E-Mail Answers

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

What is a system database and what is a user database? : sql server DBA

0 Answers

Name three advisory statistics you can collect.

1 Answers

what is ora 24313?what is the procedure to exclude that error?

0 Answers

What is replication? : sql server DBA

0 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

How to start SQL Server in minimal configuration mode?

1 Answers

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

How can you rebuild an index?

6 Answers

Datapump backup steps?

1 Answers

what r the types of backup?

5 Answers CSC,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

For more DB Administration Interview Questions Click Here