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 mean by candidate key?

0 Answers  

---

Explain about sql server login?

0 Answers  

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

How to override dml statements with triggers?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

How to find the date and time of last updated table?

3 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

Diffrent types of function

1 Answers   Wipro,

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What is CTE in SQL

0 Answers   Infosys,

---