what are the differences you find when working with oracle
91 and sql server 2005?
- 1 Answers
- 3857 Views
- Choice Solutions, I also Faced
- E-Mail Answers
Answer Posted / daid kumar
There are so many Difference in oracle 9i and Sql Server2005
some example are as follows:
in Oracle In sqlserver2005
----------------------- --------------------------
1.Schema Database
2.Block Pages
3.Segment N/A
4.Clusters N/A
5.Index(Type) Only One Type is Present
6.Materialized Views N/A
7.Operators N/A
8.Packages N/A
9.Hierarchical Operators N/A
10. In case of partition table in oracle we have Three
option and easely implemented but in Sqlserver It is complx
work Etc.........................
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is table normalization?
What are the benefits of database management system?
When does checkpoint occur?
How can you get the alternate records from the table in the sql?
What is the difference between horizontal and vertical partitioning?
List few restrictions that are imposed while creating views?
What is the difference between case version and decode version?
How do you performance tune a database?
What is a system concept?
What is rdbms and its features?
How do I create a database in open office?
What is the difference between multiload and fastload interms of performance?
What is actional flow mapping?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
