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

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

If CPU is very slow What can u do to speed up?

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

what is the role of dip user in our database?

What would you do with an "in-doubt" distributed transaction?

If we issue alter database begin backup. What happens to database?

How many packages we have in db

What is dcl? : sql server DBA

Where in the Oracle directory tree structure are audit traces placed?

what is the use of recording information about current session?

one datafile is lost in standy side how can you recover that??

What are statistics, under what circumstances they go out of date, how do you update them?

For more DB Administration Interview Questions Click Here