Answer Posted / daid kuamr

Implicite index is created by oracle Internally
ex: when we make a primary key in a Column then implicit
Index created which is Clustered Type index(Default)
while Explicite index created by "Create Index Command'
User

How are extents allocated to a segment?

1177

---

How to run create database statement?

1075

---

Can we write insert statement in function in oracle?

1153

---

How to use "in out" parameter properly?

1098

---

What is an oracle function?

1239

---

What happens to indexes if you drop a table?

1222

---

What is partitioned table in Oracle?

1265

---

How to use subqueries with the in operator using oracle?

1137

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2112

---

if you ctreate table identity

2426

---

How do you bind variables in oracle?

1017

---

How many categories of data types in oracle?

1073

---

Is truncate autocommit in oracle?

1147

---

How to see the table columns used in an index?

1070

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2352

---