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.

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.

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

What does indexation mean?

0 Answers  

---

Why we need sql server?

0 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---

What is the maximum number of index per table?

0 Answers  

---