Interested to Buy Any Domain ? << Click Here >> for more details...
what are the differences you find when working with oracle
91 and sql server 2005?
- 1 Answers
- 4155 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 a join in the sql?
What do you understand by query optimization?
What is database definition (dbd)?
Define database model.
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
What do you mean by extension and intension?
Enlist some commands of ddl, dml, and dcl.
How do I check my drivers?
What is cold backup, hot backup, warm backup recovery?
What are new features postgre 9.1?
Explain the components of rdbms?
What is database management system(dbms)?
What do you understand by database triggers?
What do you mean by cardinality and its types?
Why is normalisation used?
