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
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Query processing is slow(eg select query)how will u solve that
when does an alert gets signaled?
Which autogrowth database setting is good? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how does an oracle clusterware manage crs resources?
What authentication modes does sql server support? : sql server DBA
What is fill factor? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
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.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Why would you call update statistics? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA