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

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

Question Posted / guest

2 Answers
10784 Views
I also Faced
E-Mail Answers

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

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

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

0 Answers

How would you go about increasing the buffer cache hit ratio?

2 Answers

why we use cursors

1 Answers

why Datapump is faster than traditional export and import

4 Answers Mphasis,

Compare and contrast TRUNCATE and DELETE for a table.