Answer / appu

Access is installed as part of the Microsoft Office suite.
SQL Server can be quite expensive.
Access is more suited for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Access over SQL Server is for compatibility/sharing.
SQL Server was designed to have many hundreds, or even thousands of users accessing it at any point in time.

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

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

10 Answers  

---

How many types of triggers in sql server?

0 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

How to make remote connection in database?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

What is proper subset of candidate key?

0 Answers  

---