What is the architectural difference between Oracle and SQL
Server 2000?

If I have 100 databases, how many instances get created
when you use Oracle and how many get created when you use
SQL Server?

Answers were Sorted based on User's Feedback



What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databas..

Answer / rajganesh

100 instances gets created in Oracle , whereas in SQL one
instance can hold 100 databases

Is This Answer Correct ?    6 Yes 1 No

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databas..

Answer / kd

adding to the above answer: minimum 100 instances (but can
be more if using parallel server) can be created in Oracle.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1 Answers   Pathway Technologies,


What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  


hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  


Is it possible to drop a column in a table which contains only one column? How?

1 Answers  


what is sql*loader parameters and where we will use it.

1 Answers   Accenture,


What is Virtual Memory?

1 Answers  


Explain the payment term in ar. : oracle accounts receivable

1 Answers  


how to write customizations in po

1 Answers   Ernst Young,


What is db_recovery_file_dest in oracle? When do you need to set this value?

1 Answers  


How do you add a data file to a tablespace?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)