CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS DATABASE DETAILS
    Question :
    What is the difference between oracle 9i and 10g database?


    Posted by: tapas dey on 9/7/2008

    Contact tapas dey Contact tapas dey
    Category Database Interview Questions
    Rating (0.4) By 1554 users
    Added on 9/7/2008
    Views 2275
    Rate it!
    Answers:

    Oracle 10g has many features compare to 9i like
    asm,swr,addm,flaskback recovery,data pump.
    Generating snap shot is much more flexible in 10 g compare to 9i.



    Posted by: Suresh     

    Contact Suresh Contact Suresh

    10 G supports grid computing, ASM (Automatic storage management) and Memory management.

    Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing features

    Transparent Data Encryption
    Async commits
    CONNECT ROLE can not only connect
    Passwords for DB Links are encrypted
    New asmcmd utility for managing ASM storage
    Grid computing - an extension of the clustering feature (Real Application Clusters)
    Manageability improvements (self-tuning features)
    Performance and scalability improvements
    Automated Storage Management (ASM)
    Automatic Workload Repository (AWR)
    Automatic Database Diagnostic Monitor (ADDM)
    Flashback operations available on row, transaction, table or database level
    Ability to UNDROP a table from a recycle bin
    Ability to rename tablespaces
    Ability to transport tablespaces across machine types (E.g Windows to Unix)
    New 'drop database' statement
    New database scheduler - DBMS_SCHEDULER
    DBMS_FILE_TRANSFER Package
    Support for bigfile tablespaces that is up to 8 Exabytes in size
    Data Pump - faster data movement with expdp and impdp.

    In Oracle 9i after drop we can't rollback but we can do it in 10g.
    Moreover, 10g has additional 149 features than 9i.



    Posted by: Ramadass    

    Contact Ramadass Contact Ramadass

    Oracle 10g has certain extra features than oracle 9i like sql* plus, jserver, flashback table and flashback database. The jserver featuer was also present in Oracle 9i but it supports upto the jdk 1.2 version of Java. However flashback concept is purely new in Oracle 10g.



    Posted by: Suryanshu    

    Contact Suryanshu Contact Suryanshu

    Oracle 10g has many features compare to 9i like
    asm,swr,addm,flaskback recovery,data pump.
    Generating snap shot is much more flexible in 10 g compare to 9i.

    Automated Storage Management (ASM)
    Automatic Workload Repository (AWR)
    Automatic Database Diagnostic Monitor (ADDM)
    Flashback operations available on row, transaction, table or database level
    Ability to UNDROP a table from a recycle bin
    Ability to rename tablespaces
    Ability to transport tablespaces across machine types (E.g Windows to Unix)
    New 'drop database' statement
    New database scheduler - DBMS_SCHEDULER
    DBMS_FILE_TRANSFER Package
    Support for bigfile tablespaces that is up to 8 Exabytes in size
    Data Pump - faster data movement with expdp and impdp.



    Posted by: Kasi G    

    Contact Kasi G Contact Kasi G

    drop operation



    Posted by: suresh    

    Contact suresh Contact suresh

    it just on the bases on command or else....
    as u use some of command like inbuilt property so i think there will be more enhance in this property of the oracle more inbuilt command.......
    AS THE NEW COMMER



    Posted by: prabhakar katiyar    

    Contact prabhakar katiyar Contact prabhakar katiyar

    1.In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automated Storage Management (ASM), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) were introduced.
    2.10g is more stable than 9i. All the earlier bugs reported were fixed in 10g release.



    Posted by: R.Babu    

    Contact R.Babu Contact R.Babu

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    How to store and retrieve the image from the database in sqlserver 2005.Plz specify the codes related to this........

    View Answer
    What do you mean by slection sort and buble sort?
    please explain with example.
    View Answer
    void main()
    {
    int x=5;
    printf("%d,%d,%d
    ",x,x<<2,x<<2);
    }
    what is the ans. of this question and how?
    please explain it.
    View Answer
    What is difference between stack and queue?
    View Answer
    What is the difference between oracle and sql?
    View Answer
    Can you take Image Backups using RMAN?

    20. Can you use Back upsets created by RMAN with any other utility?
    View Answer
    How grid work. is it possible grid in 9i. how ?
    View Answer
    Why we use g with 10g .
    View Answer
    I have active redo log is it possible increase size and how?
    View Answer
    What is undo /rollback segment how you resize this ?
    View Answer
    What is steps of cloning?
    View Answer
    Any inbuilt utility of oracle available which make database mirroring ?
    View Answer
    What is lock and latch?
    View Answer
    My transaction take 30 min i want if my transaction data written in table after each 5 min . If transaction commit or rollback then do according work . this is done through pl/sql how?
    View Answer
    I want to write data from table to flat file this is possible through pl/sql how ?
    View Answer
    If i have unique key this is possible to create another unique key on table .
    View Answer
    If i have primary key this is possible to create another primary key on table.
    View Answer
    What is primary & unique key which type index oracle create when we make those key ?
    View Answer
    What is view is it possible to create index on view on view & how ?
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL Database Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0 Seconds