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 is ceil and floor in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Explain the use of record length option in exp command.
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to run queries on external tables?
What is java oracle used for?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Can select statements be used on views in oracle?
Why is oracle used?
What is the difference between post-database commit and post-form commit?
How to rename a column in an existing table?
What suggestions do you have to reduce the network traffic?
What are the uses of Database Trigger ?
What is a database schema in oracle?
how the indexes are stored in the Oracle Database?