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.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
differentiate between float and double. : Sql dba
What is bind reference and how can it be created?
What is full form of rtm?
Why do we need sharding?
What view means?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is normalization in sql?
Is sql procedural language?
What is the benefit of foreign key?
How to run pl sql program in mysql?
What is the least restrictive isolation level? : Transact sql
How do I create a sql database?
How many aggregate functions are available there in sql?
what is the difference between a local and a global temporary table? : Sql dba
Can I learn sql in a week?