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

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

Select dbtimezone from dual;

Is This Answer Correct ?

4 Yes

1 No

More DB Administration Interview Questions

What command would you use to create a backup control file?

What types of replication are supported in sql server? : sql server DBA

Explain materialized views and how they are used.

how can you connect from 10g user to 11g user??

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

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

what is the use of recording information about current session?

How would you determine the time zone under which a database was operating?

Can you redefine a table online?

What is fill factor? : sql server DBA

Name a tablespace automatically created when you create a database.

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

For more DB Administration Interview Questions Click Here