Answer / vipin

Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values

Answer / brajesh kumar srivastava

Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value

Answer / aaaaaaaaaaaaa

Primary key is a primary key that is an attribute.

Answer / alquama rizvi

MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

What is the maximum row of a size?

0 Answers  

---

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

---

What do you understand by sql server agent?

0 Answers  

---

What is Inner Join?

2 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

Explain log shipping and mention its advantages.

0 Answers  

---

Explain indexing and what are the advantages of it?

0 Answers  

---