1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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?..

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  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

Explain materialized views and how they are used.

0 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

When a user process fails, what background process cleans up after it?

1 Answers  




Name three advisory statistics you can collect.

1 Answers  

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

Which autogrowth database setting is good? : sql server DBA

0 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

For more DB Administration Interview Questions Click Here
Categories