How would you determine the time zone under which a database
was operating?
Answer Posted / raman
select DBTIMEZONE from dual;
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Query processing is slow(eg select query)how will u solve that
what is ora 24313?what is the procedure to exclude that error?
What are the steps you will take to improve performance of a poor performing query?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you schedule a job in database?
how does an oracle clusterware manage crs resources?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?