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 / venkateswararao

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

SELECT DBTIMEZONE FROM DUAL

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

What is a nvl function? How can it be used?

What is the difference between alert log file and trace file ?

How to use null as conditions in oracle?

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

Where are the settings stored for each instance in oracle?

What is connection pool in oracle?

what is load balancing and what u have used to do this?(sql loader)

The join defined by the default data link is an outer join yes or no ?

9. Display the client name and order date for all orders using the JOIN . . . USING method.

Explain oracle’s system global area (sga).

Explain the use of consistent option in exp command.

For more Oracle General Interview Questions Click Here