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 does oracle handle read consistency?

1086

---

State the difference between a primary key and foreign key?

927

---

Explain integrity constraints?

1100

---

How are extents allocated to a segment?

1118

---

What is BBED in Oracle?

1148

---

What is meant by raw datatype?

1054

---

How to create a single index for multiple columns?

1026

---

Are truncate and delete commands same? If so why?

1139

---

Can we write dml statement in function in oracle?

1074

---

Explain the difference between a procedure and a function?

1161

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2199

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1993

---

What is the difference between alert log file and tarce file ?

2162

---

Is rowid unique in oracle?

992

---

How to Truncate Table in Oracle

1148

---