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
Is nosql relational?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we create view in stored procedure?
Are pl sql variables case sensitive?
What is partition in sql query?
How do we accept inputs from user during runtime?
what is the functionality of the function htmlentities? : Sql dba
What are the different dml commands in sql?
How many sql are there?
How show all rows in sql?
What is a heap in sql?
Is sql the best database?
What is implicit cursor in pl sql?
what is the difference between primary key and unique key? : Sql dba
What is java sql driver?