Explain the use of rows option in imp command.

0 Answers  

---

What is BBED in Oracle?

0 Answers   MCN Solutions,

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

Give the different types of rollback segments.

0 Answers  

---

How to write an inner join with the where clause in oracle?

0 Answers  

---

What are synonyms used for ?

3 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

What is the usage of synonyms?

0 Answers  

---

what is kernel?

2 Answers   Microsoft,

---

What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,

---

What is the implicit cursor in oracle?

0 Answers  

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---