Answer Posted / rajat sharma

Data integrity is provided by various constrains
(UNIQUE,CHECk etc.) provided to us by SQL. By these
constrains the user cannot even make a mistake in inserting
the data.

internal architecture

2188

---

Can you redefine a table online?

1109

---

how can you implement fine-grained auditing?

1126

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1972

---

How to start SQL Server in minimal configuration mode?

7955

---

how can you initialize log miner?

1137

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2461

---

what is the diffrence between core dba and apps dba?

2566

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1282

---

What purpose does the model database server? : sql server DBA

1179

---

Why would you call update statistics? : sql server DBA

985

---

What are the different types of indexes available in sql server? : sql server DBA

1191

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2058

---

which background process invoke at the time of upgradation tell me???

2726

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1074

---