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

Which autogrowth database setting is good? : sql server DBA

786


How to start SQL Server in minimal configuration mode?

7379


What is the default port no on which sql server listens? : sql server DBA

869


How do you open a cluster administrator? : sql server DBA

816


how can you find out if a table can be redefined?

814


Why would you call update statistics? : sql server DBA

794


What the different topologies in which replication can be configured? : sql server DBA

941


What are the different ways you can create databases in sql server? : sql server DBA

844


what is grd?

874


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2237


What are the different types of upgrades that can be performed in sql server? : sql server DBA

939


how to restore files with rman?

1993


How would you extract DDL of a table without using a GUI tool?

2255


how can you schedule a job in database?

839


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1946