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

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  




How would you go about increasing the buffer cache hit ratio?

2 Answers  

How can you gather statistics on a table?

3 Answers  

Name a tablespace automatically created when you create a database.

5 Answers  

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

2 Answers  

What the different components in replication and what is their use? : sql server DBA

0 Answers  

Datapump backup steps?

1 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories