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 is the use of recording information about current session?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is dbcc? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What the different topologies in which replication can be configured? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you create a user-defined lock?
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.
What are statistics, under what circumstances they go out of date, how do you update them?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what are the benefits of flashback feature?
how can you implement fine-grained auditing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?