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

Answer Posted / b.r.reddy

Select dbtimezone from dual;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways you can create databases in sql server? : sql server DBA

599


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


Where do you find the default index fill factor and how to change it? : sql server DBA

554


Which autogrowth database setting is good? : sql server DBA

579


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2031






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

2191


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1589


What are the steps you will take to improve performance of a poor performing query?

2420


how can a session indicate its interest in receiving alerts?

563


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1981


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1724


what is a user-defined lock?

587


how does an oracle clusterware manage crs resources?

569


what is asm?

606


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1981