Answer Posted / 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 |
Post New Answer View All Answers
What the different components in replication and what is their use? : sql server DBA
internal architecture
What are the operating modes in which database mirroring runs? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : 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
what is grd?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you schedule a job in database?
What purpose does the model database server? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is transparent data encryption? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
