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
What is the difference between a primary key & a unique key?
WHAT IS ecc 6.0
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to establish administrator authentication to the server?
What is a system tablespace?
Explain the blob datatype?
What is snapshot is too old? Give and example for better understand.
How to recover a dropped table in oracle?
How to change program global area (pga) in oracle?
How to display row numbers with the records?
Can we store pictures in the database and if so, how it can be done?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is dual table oracle?
What is oracle update statement with inner join ?
Give the different types of rollback segments.
