Answer / Dr. Rajendra Kumar Singh

"In database terminology, a relationship represents the association between two or more tables. There are three main types of relationships: 1) One-to-One (1:1): Each record in one table corresponds to exactly one record in another table. 2) One-to-Many (1:N) or Many-to-One (N:1): Each record in one table can correspond to multiple records in another table, but each record in the second table corresponds to only one record in the first table. 3) Many-to-Many (N:M): Multiple records from both tables are related through a junction or linking table."n

Explain ms sql server reporting services vs crystal reports?

1 Answers  

---

What is indexing?

0 Answers   AOL,

---

Define self join?

1 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1 Answers   TCS,

---

How do I completely remove sql server instance?

1 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

What are the commands used in DCL?

1 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

Explain the etl (extraction, transformation, and loading)?

1 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

What do you understand by intent locks?

1 Answers  

---