INTERVIEW QUESTIONS DATABASE DETAILS

Question: What is the difference between oracle 9i and 10g database?

Answer: 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.

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.
Source: CoolInterview.com

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. Source: CoolInterview.com

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. Source: CoolInterview.com

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. Source: CoolInterview.com

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	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question