Answer Posted / 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 |
Post New Answer View All Answers
internal architecture
which background process invoke at the time of upgradation tell me???
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is transparent data encryption? : sql server DBA
Why would you call update statistics? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is the default port no on which sql server listens? : 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.
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
what is a user-defined lock?
how can you get actual data change values from previous transactions in oracle?
Which autogrowth database setting is good? : sql server DBA
