Explain couple pf features of SQL server
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is the synonym of join?
Is sql server free?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Explain different forms of normalization?
What is a NOLOCK?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What is sql server programming?
Explain cdc and sql injection?
Explain about remote stored procedure?
What is ms sql server index?
Describe in brief system database.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)