How would you determine the time zone under which a database
was operating?
Answer Posted / daid kumar
select * from V$NLS_Parameters
it show the Time Zone Format
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What would you do with an "in-doubt" distributed transaction?
What is dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
internal architecture
What is a correlated sub-query? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you create a user-defined lock?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Where would you look for errors from the database engine?
how can a session indicate its interest in receiving alerts?
Which autogrowth database setting is good? : sql server DBA
What is transparent data encryption? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.