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

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

597


how can a session indicate its interest in receiving alerts?

565


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.

1690


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3944


what are the types of connection load-balancing?

564






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

662


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?

2000


What is dbcc? : sql server DBA

777


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

563


What is replication? : sql server DBA

626


Explain about your sql server dba experience? : sql server DBA

549


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

599


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1903


how does an oracle clusterware manage crs resources?

573


How would you best determine why your MVIEW couldn't FAST REFRESH?

1832