Answer / Nikhil Singh Pundir

A tablespace consists of one or more datafiles and one temporary tablespace. Datafiles hold the actual data, indexes, and rollback segments for the objects in the tablespaces.

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

What is a nvl function? How can it be used?

1 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

Explain table?

1 Answers  

---

What is a oracle database?

1 Answers  

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1 Answers   EDC,

---

Why do we use bulk collect in oracle?

1 Answers  

---

What is oracle host variable?

1 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

What are the major difference between truncate and delete?

1 Answers  

---

What is using clause and give example?

1 Answers  

---