explain the
difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
- 1 Answers
- 2577 Views
- ADP, iSoft, I also Faced
- E-Mail Answers
Answer Posted / Akash Singh
Oracle SQL and Microsoft SQL Server SQL (Structured Query Language) are similar in that they are used for querying, manipulating, and managing data in databases, but there are some differences:
- Platform: Oracle SQL is a part of the Oracle Database Management System, while SQL Server SQL is a component of Microsoft SQL Server.
- Syntax: There are minor differences in syntax between the two, such as the use of double quotes for identifiers in Oracle versus square brackets in SQL Server.
- Performance and Scalability: Both databases have their strengths and weaknesses in different areas depending on factors like workload, data type, and hardware configuration. However, both are capable of handling complex and large-scale applications.
- Integration: Oracle and SQL Server can be integrated with other components within their respective ecosystems, offering more comprehensive solutions for businesses.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
What is the primary use of the model database?
Explain “row_number()” in sql server with an example?
Why we use the openxml clause?
Why and when do stored procedure recompile?
Does view occupy space?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can one drop a column from a table?
How to connect php with different port numbers?
How to remove duplicate rows from table except one?
Can we shrink data file in sql server?
Why use identity in sql server?
Why should you use or avoid select * statements?
What is sql server query analyzer?
What is subquery? Explain the properties of a subquery?
