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
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 |
A scenario for amount correction & how to use amount correction functionality in AP invoices
How would you go about increasing the buffer cache hit ratio?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
1. What is PO rate variance gain and loss?
What is store procedure?and how do u take the values from database and run in scripts?
statement string in open is null or 0 length ORA-40735
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What command would you use to create a backup control file?
Explain the use of table functions.
difference of using cursor for loop and open,fetch,close.which one is better
Give the two types of tables involved in producing a star schema and the type of data they hold.
What is the sql query to find the employee who has Nth maximum salary?