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 |
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
what is sql injection?
What are synonyms?
What does indexation mean?
What functions can a view be used to performed?
What are the types of dml?
How do I clean up sql server transaction log?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
Creating Tables Using SELECT
What are acid properties of transaction?
What is a result set object returned by odbc_exec()?
Why are sql functions used?
Oracle (3259)
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)