what are the differences you find when working with oracle 91 and sql server 20

what are the differences you find when working with oracle
91 and sql server 2005?

Question Posted / guest

1 Answers
3550 Views
Choice Solutions, I also Faced
E-Mail Answers

what are the differences you find when working with oracle 91 and sql server 2005?..

Answer / 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

More Database Management Interview Questions

Explain types of indexing in dbms?

0 Answers

What is alternate key?

0 Answers

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers

Why not phenix, the zelinka/otwinoski libraries, etc?

0 Answers

Differentiate nested loop, hash join and merge join.

0 Answers

What is the role of tables in database?

0 Answers

How to reorder the table columns (fields)?

0 Answers

What is TERM ?

1 Answers

When the SYSTEM TABLESPACE can be made off-line ?