Answer / kishore

Index is a performance tuning method of allowing faster
retrieval of records. Oracle indexing is a standing B-Tree
indexing for fast retrieval.

Syntax: CREATE INDEX EmpInfo ON Employee(EmpID,Emp_Name)

we have two types indexes

1. Clustered indexes
2. Non-Clustred indexes

Answer / ruchi

index is a data structure used for fast retrival of data.

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

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

1 Answers  

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers   Logisoft,

---

8. Supporting AP, AR and GL?

0 Answers   Oracle,

---

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

---

Explain materialized views and how they are used.

2 Answers  

---

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

0 Answers  

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

---