Answer / vani

A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.

Answer / arijit

A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.

Answer / prasad

There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.

Answer / pooja

A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.

candidate key:All that fields which can be selected as
primary key are called candidate keys.

What is executereader?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What command would you use to create an index?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How to connect PK and FK?

2 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

Explain about merge replications?

0 Answers  

---

Explain datetimeoffset data type in sal server 2008?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---