Answer Posted / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

optimization techinques

2718

---

what method you can use to reduce the overhead of Reporting Services data sources?

268

---

What is difference between rownum and row_number?

1023

---

Ways to improve the performance of a SQL Azure Database?

125

---

What are the disadvantages of using querystrings to send data from one page to another?

1071

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1307

---

How to get all stored procedures in sql server?

1059

---

How can we use ConnectorJ JDBC Driver with MS SQL?

1053

---

How many cores do I need for sql server 2016?

951

---

Can we write ddl in trigger?

969

---

Explain transaction server distributed transaction?

1037

---

What are approximate numeric data types in ms sql server?

1105

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1984

---

What is catalog views?

1121

---

What happens if you delete a table that is used by a view?

1061

---