1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

what is the use of ocr?

1 Answers   Oracle,

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

what is the diffrence between core dba and apps dba?

1 Answers   Cap Gemini,

how can you record information about current session?

1 Answers   Oracle,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1 Answers  

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

2 Answers  

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1 Answers  

For more DB Administration Interview Questions Click Here
Categories