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
How is data stored on a disk?
what is data integrity? : Sql dba
Can we create index on primary key?
What are the commands used in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is sql trigger example?
How much does sql cost?
What is nvarchar in sql?
What are stored procedures used for?
Does inner join return duplicate rows?
What is the difference between clustered and non-clustered index in sql?
What are string functions in sql?
How is pl sql different from sql?
How does cross join work?
Is not equal in sql?