Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 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.

0 Answers  

what is the use of home directory???

1 Answers   HP,

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

what are the differences of where and if in SAS?

0 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories