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

If we issue alter database begin backup. What happens to database?

2 Answers  

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

1 Answers  

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

Explain what partitioning is and what its benefit is.

2 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1 Answers  

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

If CPU is very slow What can u do to speed up?

1 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

For more DB Administration Interview Questions Click Here
Categories