From the database level, how can you tell under which time
zone a database is operating?
Can we take incremental backups in datapump?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
why Datapump is faster than traditional export and import
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
I lost one datafile i dont have backup how can you recover that???
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
What is fill factor? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different types of replication and why are they used? : sql server DBA
How can we know the exact updation date of a particular database?
Datapump backup steps?