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 is database schema?

4 Answers   Infosys,

---

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

---

How do you add a data file to a tablespace?

1 Answers  

---

what is correlated subquery

3 Answers  

---

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

---

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 Answers  

---

whats the difference between join command and Cartesian product using example?

1 Answers  

---

how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 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 does coalescing a tablespace do?

2 Answers  

---

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

---