Answer Posted / anjali
1) u have automatic undo management.
2)u have automatic segment space management
3)u got these locally managed tablespaces which is better
than the dictionary managed tabespaces as u can avoid
fragmentation with locally managed tablespaces.
4)u have a new dbms_metadata package to extract object
definitions from database.
5)multi table insert is possible with 9i
6)importanly u have this spfile in 9i.
7) also u have dynamic memory mangement facility with 9i.
8) u have tuning advisories with 9i.
9) u have multi block size parameter with 9i and many more
features like these
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What would you do with an in-doubt distributed transaction?
What is snapshot is too old? Give and example for better understand.
What is user managed backup in Oracle?
Explain oracle left join with an example?
What is an oracle tablespace?
What is an oracle database table?
Is it possible to insert comments into sql statements return in the data model editor ?
How to create a table index?
Use of an integrity constraint is better to validate data. Explain
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Describe varray?
What is a trigger and what are its types in oracle?
What is key preserved table?
How can I get column names from a table in oracle?
What is a read only transaction in oracle?
