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

Differentiate between post-database commit and post-form commit?

1029

---

does the query needs a hint to access a materialized view?

1857

---

What is the sql query to concatenate column values from multiple rows in oracle?

1051

---

Can we store pictures in the database and if so, how it can be done?

1029

---

How do I spool to a csv formatted file using sqlplus?

1027

---

What is Virtual Private Database in Oracle?

1083

---

What is an oracle wallet?

938

---

What is dual table oracle?

980

---

How can I create database in oracle?

1010

---

What happens if variable names collide with table/column names?

1177

---

Explain the truncate in oracle?

963

---

Explain the use of parfile option in exp command.

1063

---

Is there any function in oracle similar like group_concat of mysql?

1049

---

How can we create the complete backup of data in the oracle.

2152

---

How do I manually create a database in oracle?

1014

---