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.

What is inner join in sql server joins?

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

What is 2nf example?

0 Answers  

---

Do you know what is difference between index seek vs. Index scan?

0 Answers  

---

How do you start single user mode in clustered installations?

0 Answers  

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

What is row-level compre?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

What is awe?

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---