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
how can you initialize log miner?
How do you open a cluster administrator? : sql server DBA
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
how can you find out if a table can be redefined?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is logical system in sap basis
How to start SQL Server in minimal configuration mode?
what is the use of recording information about current session?
how can you get actual data change values from previous transactions in oracle?
what is ora 24313?what is the procedure to exclude that error?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different types of database compression introduced in sql server 2008? : sql server DBA