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

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

Can you redefine a table online?

0 Answers Oracle,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

Why would you use sql agent? : sql server DBA

0 Answers

which background process will run @ the time of creation of catalog database

1 Answers CSC,

internal architecture

0 Answers CSC,

What type of index should you use on a fact table?

1 Answers

wat is global index and local indes

1 Answers Oracle,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

How would you force a log switch?

4 Answers

For more DB Administration Interview Questions Click Here