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

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

Question Posted / narmada kumari

1 Answers
4340 Views
I also Faced
E-Mail Answers

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

Answer / b.r.reddy

Select dbtimezone from dual;

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More DB Administration Interview Questions

Explain what partitioning is and what its benefit is.

2 Answers

What the different topologies in which replication can be configured? : sql server DBA

0 Answers

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

what is logical system in sap basis

0 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

what is the differnce between process and thread ?

1 Answers IBM,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

How can you enable a trace for a session?

1 Answers

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

0 Answers

For more DB Administration Interview Questions Click Here