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


Please Help Members By Posting Answers For Below Questions

what is asm?

615


What authentication modes does sql server support? : sql server DBA

700


Why would you use sql agent? : sql server DBA

582


What are the different types of database compression introduced in sql server 2008? : sql server DBA

570


what is the use of recording information about current session?

574






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

1650


What are the different types of indexes available in sql server? : sql server DBA

575


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

565


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1977


when does an alert gets signaled?

584


how can a session indicate its interest in receiving alerts?

567


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1909


What are the different sql server versions you have worked on? : sql server DBA

547


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

660


what do you understand by flashback feature of oracle?

564