Answer / raman

select DBTIMEZONE from dual;

Answer / daid kumar

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

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

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.

0 Answers   Infosys,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---