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
How would you best determine why your MVIEW couldn't FAST REFRESH?
What purpose does the model database server? : sql server DBA
which background process invoke at the time of upgradation tell me???
What are the commands you'd issue to show the explain plan for "select * from dual"?
what do you understand by flashback feature of oracle?
Explain about your sql server dba experience? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How can you control the amount of free space in your index pages? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you extract DDL of a table without using a GUI tool?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
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?