Explain couple pf features of SQL server

Answer Posted / vimsssssssssss

1. A database administrator can manage over 65 critical SQL
server databases, where as the same administrator can
manage only 15 Oracle critical databases.
2. SQL server is more user friendly and takes less time to
install when compared to Oracle server.
3. SQL server also has advanced features like advanced
compression, data mining, partitioning, OLAP, enterprise
reporting included in the package, while businesses who use
Oracle servers have to purchase these features separately.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we partition data?

611


Explain what are the database objects? : SQL Server Architecture

557


What is reportserver and reportservertempdb ?

107


Explain following error properties?

555


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

581






Explain forward - only cursors?

513


How can you start sql server in different modes?

500


Why I am getting this error when renaming a database in ms sql server?

536


Explain the database you used in your final year project?

532


What are xml indexes?

523


What is trigger and different types of Triggers?

568


What is indexed view? How to create it?

592


Explain transaction server auto commit?

531


What does man by sql wildcard characters in sql server?

515


What is a result set object returned by mssql_query()?

571