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 the syntax to add a record to a table?
How do I count rows in sql query?
What does the hierarchical profiler does?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How do you know if a relationship is 2nf?
Which kind of parameters cannot have a default value in pl sql?
What is the mutating table and constraining table?
Describe sql comments?
What is the purpose of my sql?
Where is pl sql used?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Does a user_objects view have an entry for a trigger?
What is difference between procedure and trigger?
What is difference between sql and mysql?
What is package in pl sql with an examples?
