How can we know the exact updation date of a particular database?

How can we know the exact updation date of a particular
database?

Question Posted / sqlprabha

Answers were Sorted based on User's Feedback

How can we know the exact updation date of a particular database?..

Answer / pavana kumar.s

Just query the registry$history view in oracle to view the las t exact date of update.

Is This Answer Correct ?

2 Yes

0 No

How can we know the exact updation date of a particular database?..

Answer / guest

Schdule a job for required database.
Every day it will give the job history.

Is This Answer Correct ?

5 Yes

5 No

More DB Administration Interview Questions

what is the role of dip user in our database?

how can you get actual data change values from previous transactions in oracle?

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

How would you begin to troubleshoot an ORA-3113 error?

Can you redefine a table online?

what is the last version,the release date of that version and fix pack of ibm db2 udb?

what is asm?

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

What are the operating modes in which database mirroring runs? : sql server DBA

how can you create a user-defined lock?

Give the reasoning behind using an index.

Give two examples of referential integrity constraints.

For more DB Administration Interview Questions Click Here