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.

0 Answers   TCS,

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

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

0 Answers  

---

How to manage transaction isolation level?

0 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

What is a shared pool?

1 Answers  

---

How can we find out the current date and time in oracle?

0 Answers  

---

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

How to use in conditions in oracle?

0 Answers  

---

What is Hash Index?

1 Answers  

---

Explain oracle’s system global area (sga).

0 Answers  

---