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

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  


what is shared memory?

1 Answers   IBM,


Where would you look for errors from the database engine?

2 Answers   Fintellix,


When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  


default triggers available for reports

0 Answers  






how to replace not in with not exist?

0 Answers   IBM,


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,


Name three advisory statistics you can collect.

1 Answers  


What view would you use to look at the size of a data file?

1 Answers  


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  


Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)