Answer Posted / vimalssssss
1.SQL server is more user friendly and takes less time to
install
2.A database administrator can manage comparatively more
number of SQL server databases than Oracle
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
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain Reporting Life Cycle?
What is the sql server 2000 version number?
How can you start sql server in different modes?
What is the difference between a "where" clause and a "having" clause?
What is the difference between stored procedure and user defined functions?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Name and describe few console utilities for ssrs?
Describe triggers features and limitations?
How can you tell if a database object is invalid?
Can We Use Data-grids For Our Report In Ssrs?
What is difference statement and preparedstatement?
What is a non-clustered index?
What is the maximum size of sql server database?