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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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.
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.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What would you do with an "in-doubt" distributed transaction?
internal architecture
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the operating modes in which database mirroring runs? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is the diffrence between core dba and apps dba?
What is fill factor? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to