Answer Posted / dhara

-> It is one of the most important concepts in the study of
the RDBMS.
->Tables that are hugged and bilky often defeat the purpose
of having an RDBMS all togather. This is because such
tables may not be easy to maintain.
->There are two ways of approching logical database design-
the top down approch
the botton up approch

Give the different types of rollback segments.

1031

---

What is oracle thin client?

1029

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1691

---

How to empty your oracle recycle bin?

1026

---

what happened to the global index when I truncate the data in one of the partition?

2027

---

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

1037

---

What is data file?

1110

---

List the various oracle database objects?

1061

---

Can you drop an index associated with a unique or primary key constraint?

1022

---

How to import one table back from a dump file?

1027

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

---

Does facebook use oracle?

1038

---

How to initialize variables with default values?

1250

---

How to omit columns with default values in insert statement in oracle?

1050

---

What is a nested table?

1069

---