Answer Posted / siva

There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.

The custom and recommended types are of 2 types
Implicit index and Explicit index.

How to use in conditions in oracle?

1058

---

What is recycle bin in Oracle?

1153

---

What to do if the startbd.bat failed to start the xe instance?

1084

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2266

---

What is the use of aggregate functions in oracle?

1026

---

What is integrity and what is constraint??Explain with example

2284

---

What are the ansi data types supported in oracle?

947

---

Why we use bulk collect in oracle?

1044

---

How do we create privileges in oracle?

1047

---

How to rebuild an index in oracle?

1028

---

Query to retrieve record for a many to many relationship ?

2520

---

Why does Oracle not permit the use of PCTUSED with indexes?

2426

---

How many types of tables are there in oracle?

1061

---

How to convert raw data type into text in oracle? Explain

993

---

What is the minimum client footprint required to connect c# to an oracle database?

1096

---