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

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

More DB Administration Interview Questions

If CPU is very slow What can u do to speed up?

What is the difference between LMT & DLT?

What happens on checkpoint? : sql server DBA

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

what is the use of home directory???

WHEN DOWN TIME WHAT CAN U DO?

Where in the Oracle directory tree structure are audit traces placed?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

what is the use of ocr?

How can we see the database version in os level

Explain the concept of the DUAL table.

Compare and contrast TRUNCATE and DELETE for a table.

For more DB Administration Interview Questions Click Here