i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,

---

Give the reasoning behind using an index.

2 Answers  

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

---

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

---

How can you rebuild an index?

1 Answers  

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

---

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

---