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

What is bulk copy or bcp in oracle?

1058

---

Where are the settings stored for each instance in oracle?

1070

---

What are the restrictions in a oracle read only transaction?

978

---

Explain the use of analyse option in exp command.

1073

---

How to convert character types to numeric types?

1059

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2311

---

What are the advantages of oracle?

967

---

What is oracle data type?

907

---

What is a user role in oracle?

1075

---

What are the logical operations?

1070

---

How many categories of data types in oracle?

970

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1963

---

Explain the use of full option in exp command.

1063

---

What is blob datatype?

1063

---

How to update a table row with a record?

967

---