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 the last version,the release date of that version and fix pack of ibm db2 udb?
Where would you look for errors from the database engine?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is transparent data encryption? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What are statistics, under what circumstances they go out of date, how do you update them?
when does an alert gets signaled?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you schedule a job in database?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What happens on checkpoint? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.