Answer Posted / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

What are transaction isolation levels supported by oracle?

1013

---

Why packages are used in oracle?

1011

---

What is key preserved table?

969

---

What are the oracle built-in data types?

1024

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1946

---

Difference between inner join vs where ?

989

---

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?

2216

---

What is java oracle used for?

981

---

How to manage transaction isolation level?

957

---

What is meant by joins? List out the types of joins.

969

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2141

---

What are the tools for Oracle ?

1015

---

How to create a new user account in oracle?

966

---

How to open and close an explicit cursor in oracle?

1012

---

How can you use check constraints for self referential integrity?

926

---