Answer / raman

select DBTIMEZONE from dual;

Answer / daid kumar

select * from V$NLS_Parameters
it show the Time Zone Format

If we issue alter database begin backup. What happens to database?

2 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

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?

0 Answers   EDS,

---

How can we see the database version in os level

6 Answers   Oracle,

---

What is dbcc? : sql server DBA

0 Answers  

---

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?

0 Answers   HSBC,

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---