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
10947 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

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

what r the types of backup?

5 Answers CSC,

How would you force a log switch?

4 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

How do you add a data file to a tablespace?

3 Answers

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

Give the reasoning behind using an index.

2 Answers

How can you enable a trace for a session?

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

For more DB Administration Interview Questions Click Here