Answer / Mohd Arif Usman

In SQL Server, a Candidate Key is a column or set of columns that can uniquely identify each row in a table. An Alternate Key is another set of columns that can also be used to uniquely identify the rows, but it's not the primary key. A Composite Key is a combination of two or more columns that together form a unique identifier for each row.

How to find the source of a table in sql server?

1 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

Explain the steps needed to create a scheduled job?

1 Answers  

---

Can XML be used to access data?

2 Answers  

---

Differentiate between delete and truncate.

1 Answers  

---

What is the sql case statement used for?

1 Answers  

---

When cursors are useful?

1 Answers  

---

Tell me about normalization in DBMS.

1 Answers   Honeywell, Zomato,

---

What is partitioned view?

1 Answers  

---

What command do we use to rename a database?

1 Answers  

---

Explain primary key?

1 Answers  

---

Why use triggers?

1 Answers  

---