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?
- 2 Answers
- 5471 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is Restricted Mode of Instance Startup in Oracle?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
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
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
What is an Oracle database Partial Backup?
Give two methods you could use to determine what DDL changes have been made.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
How would you determine who has added a row to a table?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
statement string in open is null or 0 length ORA-40735
Explain materialized views and how they are used.
Oracle General 
