Answer / Pankaj Pal

Oracle 9i is an older database management system, and its full version may not be legally available for free download. I recommend you to check official Oracle websites or purchase a license if necessary.

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1 Answers   TCS,

---

Explain the use of record length option in exp command.

1 Answers  

---

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

What is ADDM Advisor in Oracle?

1 Answers   MCN Solutions,

---

How view is different from a table?

1 Answers  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

How can you use check constraints for self referential integrity?

1 Answers  

---

What is a private synonym?

1 Answers  

---

What are the uses of Rollback Segment ?

2 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1 Answers  

---

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

---