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 |
What is the Query Optimizer. How you optimize your qeury.
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
what is correlated subquery
what is different between inline query,subquery& corelated query?
How can you enable a trace for a session?
how can it possibble to see the report output in excel sheet in oracle applications
What is an Oracle database Full Backup?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What are different types of receipt reversals ? Explain them : oracle accounts receivable
How can you rebuild an index?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE