Answer / sapan saxena

Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.

What is the difference between coalesce() & isnull()?

0 Answers  

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

What is the correct order of the logical query processing phases?

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

How many types of database relationship in sql server?

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

What is the use of @@spid?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

Which are the olap features?

0 Answers  

---