Answer Posted / rohit

In Oracle there are two types of SQL index namely, implicit and explicit.
Implicit Indexes:
They are created when a column is explicity defined with PRIMARY KEY, UNIQUE KEY Constraint.
Explicit Indexes:
They are created using the "create index.. " syntax.
NOTE:
1) Even though sql indexes are created to access the rows in the table quickly, they slow down DML operations like INSERT, UPDATE, DELETE on the table, because the indexes and tables both are updated along when a DML operation is performed. So use indexes only on columns which are used to search the table frequently.
2) Is is not required to create indexes on table which have less data.
3) In oracle database you can define up to sixteen (16) columns in an INDEX.

Explain do view contain data?

938

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2001

---

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

1016

---

How will you write a query to get a 5th rank student from a table student_report?

1812

---

How to execute a stored program unit?

1001

---

How to change program global area (pga) in oracle?

1031

---

how may join possible between (requisition with purchase order)

2164

---

What is a sub query and what are the different types of subqueries?

1069

---

State any two functions of oracle?

978

---

What are the different editions of oracle?

1043

---

Difference between inner join vs where ?

976

---

Explain self joins in oracle?

945

---

What is private procedure oracle?

952

---

What is a subquery?

1054

---

Explain what are the different type of segments?

910

---