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
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.
what is asm?
What are the commands used in dcl? : sql server DBA
What happens on checkpoint? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What is dcl? : sql server DBA
what is the use of ocr?
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 commands you'd issue to show the explain plan for "select * from dual"?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
internal architecture