Answer / Tarun Rohiley

1. Primary Key: A column or set of columns in a table that uniquely identifies each record and ensures data integrity by enforcing unique values.
2. Secondary Key: A candidate key that does not serve as the primary key but still uniquely identifies each record in a table.
3. Alternate Key: Another name for secondary key, it is used when we have more than one candidate key in a table and want to define another key apart from the primary key.
4. Candidate Key: A column or set of columns that can serve as a primary key because they uniquely identify each record in a table.

What is nvarchar max in sql?

1 Answers  

---

Why is a primary key important?

1 Answers  

---

What is synonyms?

1 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1 Answers  

---

What is data manipulation language?

1 Answers  

---

How do you use join?

1 Answers  

---

What are operators available in sql?

1 Answers  

---

Is sqlite good enough for production?

1 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

Why procedure is used in sql?

1 Answers  

---

What is left inner join in sql?

1 Answers  

---

What is group by in sql?

1 Answers  

---