Answer / nishi

Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

0 Answers  

---

List out the types of joins.

0 Answers  

---

What is an oracle transaction?

0 Answers  

---

Explain parameter file in oracle.

0 Answers  

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  

---

How would you design a database for an e-commerce website?

1 Answers  

---

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

---

Please explain joins in oracle?

0 Answers  

---

Can we insert data in view oracle?

0 Answers  

---

What is the difference between implicit index and explicit index?

2 Answers   TCS,

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers   GTL,

---