Answer Posted / priya tyagi

1.In Oracle 8i defualt table space is dictionary managed
where as in 9i it is locally managed.
2.oracle 8i doesn't provide auto undo segment managment
where as 9i provides auto undo segment managment .
3.in 8i multi table insert is not possible where as it is
present in 9i.
4.in 8i Dynamic memory managment facility is not present
which is present in oracle 9i.

Which sql most popular?

978

---

What is a unique key and primary key and foreign key?

959

---

What is sql stand for?

972

---

what is text? : Sql dba

1060

---

What is the basic form of sql query?

927

---

What is mutating sql table?

1091

---

How sql query is executed?

1115

---

Why functions are used in sql?

975

---

Can I call a procedure inside a function?

988

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

939

---

how to start mysql server? : Sql dba

1182

---

What is sql and also describe types of sql statements?

1041

---

Why is theta join required?

1127

---

how can we destroy the cookie? : Sql dba

997

---

What is the best sql course?

973

---