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

Explain the use of table functions.

1 Answers  

What authentication modes does sql server support? : sql server DBA

0 Answers  

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  




Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

how can you record information about current session?

0 Answers   Oracle,

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.

0 Answers  

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

0 Answers   Oracle,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories