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
What is bind variable in pl sql?
What is field delimiter?
Can we use commit inside a trigger?
Which is faster subquery or join?
What are the rules to be applied to nulls whilst doing comparisons?
Why query optimization is needed?
What has stored procedures in sql and how we can use it?
what are integrity rules?
What does pl sql stand for?
Can we group by two columns in sql?
what are the difference between clustered and a non-clustered index? : Sql dba
Explain the working of foreign key?
What is the most restrictive isolation level? : Transact sql
What are the sql aggregate functions?
What is sql scripting?