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.

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

What is supporting issues GL AP and AR?

0 Answers   Oracle,

---

How would you determine the time zone under which a database was operating?

1 Answers  

---

deference between & and &&

2 Answers   Mphasis,

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Explain the use of table functions.

0 Answers  

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

---

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

1 Answers  

---