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 system stored procedures?

0 Answers  

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

How to turn off warning messages during php execution?

0 Answers  

---

What is blocking and how would you troubleshoot it?

2 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

Why and when do stored procedure recompile?

0 Answers  

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

Explain about nested stored procedure?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---