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

Answer Posted / b.r.reddy

Select dbtimezone from dual;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start SQL Server in minimal configuration mode?

7411


What are the different types of database compression introduced in sql server 2008? : sql server DBA

854


how can you record information about current session?

777


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1838


what is logical system in sap basis

1412


How do you troubleshoot errors in a sql server agent job? : sql server DBA

858


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2147


what is a user-defined lock?

803


What is a system database and what is a user database? : sql server DBA

874


How do you trace the traffic hitting a sql server? : sql server DBA

1217


what is a crs resource?

905


What are the commands used in dcl? : sql server DBA

815


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2014


What are the recovery models for a database? : sql server DBA

866


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

2235