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

Answers were Sorted based on User's Feedback



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

Answer / raman

select DBTIMEZONE from dual;

Is This Answer Correct ?    12 Yes 3 No

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

Answer / daid kumar

select * from V$NLS_Parameters
it show the Time Zone Format

Is This Answer Correct ?    7 Yes 3 No

Post New Answer

More DB Administration Interview Questions

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


how can you connect from 10g user to 11g user??

0 Answers   HP,


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

1 Answers  


What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,


How would you force a log switch?

4 Answers  






i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,


How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  


How to start SQL Server in minimal configuration mode?

1 Answers  


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  


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

0 Answers  


what is meant by gateway

1 Answers   IBM,


who owns the operating system files created by the utl_file package?

0 Answers   Oracle,


Categories