How would you determine the time zone under which a database
was operating?
- 2 Answers
- 9816 Views
- I also Faced
- E-Mail Answers
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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what are the benefits of flashback feature?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How would you go about verifying the network name that the local_listener is currently using?
what are the types of connection load-balancing?
what is the diffrence between core dba and apps dba?
Why would you call update statistics? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is dbcc? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How can you control the amount of free space in your index pages? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What the different types of replication and why are they used? : sql server DBA
