Answer Posted / arun

schema is a combination of fact & dimension table.(in simple way)

What is the implicit cursor in oracle?

1170

---

What is an Oracle index?

1701

---

What is the data pump export utility?

1132

---

Explain the use of indexes option in imp command.

1261

---

Explain the use of consistent option in exp command.

1140

---

What is data type in oracle?

1183

---

How to calculate date and time differences in oracle?

1097

---

What is merge statement used for?

1075

---

What are advantages of dateset in datastage?

2309

---

How translate command is different from replace?

1141

---

what is the use of system.effective.date variable in oracle?

1161

---

What is columnar storage what is the advantage?

1121

---

Explain oracle 12c new features for developers?

1125

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1051

---

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

1087

---