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 a field name?
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
Differentiate between mongodb vs. Sql server?
What command is used to rename the database?
Why and when do stored procedure recompile?
What is a Linked Server?
What is trigger and different types of Triggers?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is entity data services?
What is db stored procedure?
What is a trigger?
how to create a scrollable cursor with the scroll option? : Sql server database administration
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)