Answer Posted / kumar swamy naidu

1.implicit

2.explicit
2.1.simple/b+tree index
2.2.bitmap index
2.3.reserved key index
2.3.composite index
2.4.function based index
2.5.partition index
2.6.domain index
2.7.text index
2.8.cluster index

Name the three major set of files on disk that compose a database in Oracle?

1062

---

How to resolve name conflicts between variables and columns?

977

---

Explain what are the advantages of views?

1012

---

Are truncate and delete commands same? If so why?

1075

---

What is the sid in oracle?

893

---

Can select statements be used on views in oracle?

979

---

How to apply filtering criteria at group level in oracle?

985

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

---

what is port in oracle? how is it related to database application.

1892

---

How to create a new table by selecting rows from another table?

1015

---

How to create additional tablespaces for an new database?

968

---

Name the various constraints used in oracle?

968

---

Is insert autocommit in oracle?

1013

---

Explain what are the characteristics of data files?

1029

---

What is define in oracle?

998

---