GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 35 of 81    Print  
what are the extra features available in Oracle 9i as compared to oracle 8i

  
Total Answers and Comments: 7 Last Update: February 13, 2007     Asked by: Divya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 22, 2006 09:54:19   #1  
opbang Member Since: March 2006   Contribution: 46    

RE: what are the extra features available in Oracle 9i...

In comparison with Oracle 8i 9i is have lot many new features. important is

Dynamic database parameters

Data Guard

Log Miner

Enhanced RMAN

Enhanced for Data Warehousing

Real Application Cluster

Zero Data Loss Log Transport

Granular Control over resources

Three Tier Security

Enhanced Java Support

Enhanced Data management

and many more

Oracle9i Database new features are in the categories listed below.

Availability

Scalability

Performance

Security

Manageability

Development Platform for E-Business Applications

Windows Integration

Internet Content Management

E-Business Integration

Packaged Applications

Business Intelligence


 
Is this answer useful? Yes | No
September 27, 2006 03:46:32   #2  
Divya        

RE: what are the extra features available in Oracle 9i...
Thanks OM Prakash for ur kind help...
 
Is this answer useful? Yes | No
October 05, 2006 09:31:01   #3  
sree        

RE: what are the extra features available in Oracle 9i...

date functions.

generic functions


 
Is this answer useful? Yes | No
October 16, 2006 08:00:58   #4  
manoj k jena        

RE: what are the extra features available in Oracle 9i...

Hi

plz send me the answer.


 
Is this answer useful? Yes | No
October 27, 2006 02:01:24   #5  
PAWANAHUJAHUJA Member Since: October 2006   Contribution: 6    

RE: what are the extra features available in Oracle 9i...

the extra features in 9i as

support ANSI join sysntax merge statement debugging java stored procedure

case statement.

Regards

Pawan Ahuja.


 
Is this answer useful? Yes | No
February 13, 2007 12:59:47   #6  
geetha24 Member Since: March 2006   Contribution: 27    

RE: what are the extra features available in Oracle 9i...
New Features in 9i are1. Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps
 
Is this answer useful? Yes | No
February 13, 2007 13:08:20   #7  
geetha24 Member Since: March 2006   Contribution: 27    

RE: what are the extra features available in Oracle 9i...
New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape