Answer / Nitesh Ranjan

Joins in SQL allow combining data from two or more tables based on a common column, known as the join key. There are four main types of joins: 1) Inner Join: Returns only the matching records from both tables. 2) Left (Outer) Join: Includes all records from the left table and matching records from the right table. If there is no match, NULL values are displayed for the right table columns. 3) Right (Outer) Join: Works similarly to a left join but returns all records from the right table and matching records from the left table. 4) Full Outer Join: Returns all records when there is a match in either table, with NULL values for missing records.

Does hive support indexing?

1 Answers  

---

What number sorts of privileges are accessible in sql?

1 Answers  

---

Where do we use trace frag?

1 Answers  

---

What is default port number for sql server 2000?

1 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

1 Answers  

---

Explain how many types of relationship?

1 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

List the different types of collation sensitivities in sql server?

1 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

How to configure and test odbc dsn settings?

1 Answers  

---

What is a rownum?

1 Answers  

---

Will count(column) include columns with null values in its count?

1 Answers  

---