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

types of indexes and the rationale behind choosing a particular index for a situation.

Describe the different type of Integrity Constraints supported by ORACLE ?

How to select all columns of all rows from a table in oracle?

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

How to revoke create session privilege from a user in oracle?

What privilege is needed for a user to create tables in oracle?

What is self-referential integrity constraint ?

How to remove a row in a database table?

Please explain oracle data types with examples?

How to add a new column to an existing table with a default value?

Explain how you would restore a database using RMAN to Point in Time?

how to find the second highest salary in a given table????

For more Oracle General Interview Questions Click Here