Answer / anuradha

Select Item_Name,
Item_Cost,
Round(Item_Cost, -2) Hundred_Round,
Round(Item_Cost, -1) Ten_Round,
Round(Item_Cost, 0) Unit_Round,
Round(Item_Cost, 1) Tenth_Round,
Round(Item_Cost, 2) Hundredth_Round
From Items;

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

---

How to update values on multiple rows in oracle?

0 Answers  

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

How to use subqueries with the exists operator in oracle?

0 Answers  

---

What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

---

various types of joins

9 Answers  

---

How many memory layers are in the shared pool?

1 Answers  

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

0 Answers   Oracle,

---

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

10 Answers   Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

Why do we use coalesce function in oracle?

0 Answers  

---