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 is asm?
What authentication modes does sql server support? : sql server DBA
Why would you use sql agent? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is the use of recording information about current session?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the different types of indexes available in sql server? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
when does an alert gets signaled?
how can a session indicate its interest in receiving alerts?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different sql server versions you have worked on? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what do you understand by flashback feature of oracle?