what is incremental checkpoint?
Answer / shwetha
During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.
Is This Answer Correct ? | 4 Yes | 7 No |
Name two files used for network connection to a database.
What purpose does the model database server? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Give two examples of referential integrity constraints.
what is the difference between db2start command and start database manager command?
How do you open a cluster administrator? : sql server DBA
Which dictionary tables and/or views would you look at to diagnose a locking issue?
If CPU is very slow What can u do to speed up?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
If we issue alter database begin backup. What happens to database?
What authentication modes does sql server support? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB