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

How would you go about verifying the network name that the local_listener is currently using?

2105

---

How to rebuild an index in oracle?

1069

---

What is a database schema in oracle?

1148

---

In oracle there is column command, how will you explain that?

1135

---

Explain the function of optimizer in oracle?

1196

---

How to fetch the row which has the max value for a column?

1042

---

definition of cluster and non-clustered index?

3099

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2202

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1436

---

How to enter a new row into a table interactively?

1048

---

How to declare a local variable?

1171

---

What are data pump export and import modes?

1110

---

What is the difference between translate and replace?

1115

---

Explain the use of parfile option in exp command.

1138

---

How to recover a dropped table in oracle?

1093

---