How would you determine the time zone under which a database
was operating?

Answer Posted / raman

select DBTIMEZONE from dual;

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you initialize log miner?

688


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

659


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

674


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

686


Where do you find the default index fill factor and how to change it? : sql server DBA

670






what is logical system in sap basis

1241


How to start SQL Server in minimal configuration mode?

7102


what is the use of recording information about current session?

658


how can you get actual data change values from previous transactions in oracle?

698


what is ora 24313?what is the procedure to exclude that error?

2197


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

660


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

687


What is transparent data encryption? : sql server DBA

648


What are the commands you'd issue to show the explain plan for "select * from dual"?

1806


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

649