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 are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

what is the use of recording information about current session?

0 Answers   Oracle,

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

1 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  




What are the commands used in dcl? : sql server DBA

0 Answers  

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

Can we take incremental backups in datapump?

1 Answers  

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

what do you understand by fine-grained auditing?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories