hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
- 7 Answers
- 11979 Views
- Google, TCS, Unisys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shwetabh vishnoi
Oracle should be used as it is used by large scale data
handling companies and it provides more efficient data
administrative tools also it provides full support to Java
Technology which is used mostly.
| Is This Answer Correct ? | 9 Yes | 0 No |
Explain in brief how sql server enhances scalability of the database system?
Is it possible for a stored procedure to call itself or recursive stored procedure?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to modify an existing stored procedure in ms sql server?
Why should we go for stored procedures? Why not direct queries?
What is the New in SQL server 2008?
How many types of built in functions are there in sql server 2012?
Explain what are commit and rollback in sql?
What is spatial and temporal data?
What is rolap and its advantage? : sql server analysis services, ssas
What is page in sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
