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 are the benefits of flashback feature?
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 is transparent data encryption? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Query processing is slow(eg select query)how will u solve that
suppose you want to audit specific activities on sensitive data. How can you achieve that?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you enable flashback feature?
What the different topologies in which replication can be configured? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different ways you can create databases in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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
how can you generate profile of pl/sql applications to identify performance bottlenecks?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba