Answer / sravanthi

The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.

1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.

What is optimization and its types?

0 Answers  

---

Can you explain what is indexed view? How to create it?

0 Answers  

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

How many types of database relationship in sql server?

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

Explain what is analysis service repository?

0 Answers  

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is an index. What are the types?

0 Answers  

---

Repair mdf file

2 Answers  

---