Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can I introduce multiple conditions in like operator?
what is IDE,DMV in sql server?
Can we connect to ORACLE db using Windows Authentication?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What do you know about normalization? Explain in detail?
What is an oracle recycle bin?
How to login to the server without an instance?
Can we save images in a database and if yes, how?
How to update values on multiple rows in oracle?
interview questions with answer for cts
How index is implemented in oracle database?
What is a oracle database?
Why do we use bulk collect in oracle?
What is the Tune Query
