How would you determine the time zone under which a database
was operating?
Answer Posted / raman
select DBTIMEZONE from dual;
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
which background process invoke at the time of upgradation tell me???
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can a session indicate its interest in receiving alerts?
what is asm?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is dcl? : sql server DBA
how can you communicate with operating system files from oracle?
what is a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?