Answer Posted / manjeet kumar

The disadvantages of a hierarchical database are:

·lack of flexibility (non-hierarchical relationships are
awkward to represent; redundancy may be required),
·poor performance for non-hierarchical accesses,
·lack of maintainability (changing relationships may
require physical reorganization of data).

What privilege is needed for a user to insert rows to tables in another schema?

1057

---

How to pass a cursor variable to a procedure?

1158

---

How to find out what oracle odbc drivers are installed?

1092

---

How do I connect to oracle database?

1198

---

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

1097

---

How to view the tablespaces in the current database?

1026

---

What is truncate oracle?

1015

---

What is meant by recursive hints in oracle?

1131

---

Whats the benefit of dbms_stats over analyze?

2065

---

What do you mean by merge in oracle and how can you merge two tables?

1007

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2118

---

6. Display the client name and order date for all orders using the traditional method.

2362

---

How to define a data source name (dsn) in odbc manager?

1082

---

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

1099

---

How to revoke create session privilege from a user in oracle?

1068

---