From the database level, how can you tell under which time
zone a database is operating?



From the database level, how can you tell under which time zone a database is operating?..

Answer / b.r.reddy

Select dbtimezone from dual;

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More DB Administration Interview Questions

Can we take incremental backups in datapump?

1 Answers  


Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


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.

0 Answers   Infosys,


I lost one datafile i dont have backup how can you recover that???

2 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,


What is fill factor? : sql server DBA

0 Answers  


how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,


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  


What the different types of replication and why are they used? : sql server DBA

0 Answers  


How can we know the exact updation date of a particular database?

2 Answers   Satyam,


Datapump backup steps?

1 Answers  


Categories