Interested to Buy Any Domain ? << Click Here >> for more details...
How would you determine the time zone under which a database
was operating?
- 2 Answers
- 10828 Views
- I also Faced
- E-Mail Answers
Answer Posted / raman
select DBTIMEZONE from dual;
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why would you call update statistics? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is transparent data encryption? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What the different types of replication and why are they used? : sql server DBA
how can you process messages in order asynchronously?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
who owns the operating system files created by the utl_file package?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Explain materialized views and how they are used.
