Answer Posted / mohan kuamr

# 3

The main four query statements are:-
1.) select
ex:select * from table_name

2.) insert
ex:insert into table_name(c1,c2,c3...) values(v1,v2,v3..)

3.) delete
ex: delete * from table_name

4.) update
ex:update table_name
set col_name='value'
where col_name='something'
note:examples are based on ms sql server database.k

Explain the difference between control flow and data flow?

1061

---

What is SQL Azure Fabric?

112

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1249

---

Where is trigger in sql server?

1105

---

Distinguish between commit and rollback?

1011

---

What is a data collection table?

1051

---

What is the difference between a stored procedure and a user defined function?

1066

---

What are indexes in sql?

1351

---

What is normalization 1nf 2nf 3nf?

1109

---

What is an identity?

1076

---

Which are ddl commands?

1114

---

What are out-of-range errors with date and time literals?

1094

---

List the types of recovery model available in sql server?

971

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1038

---

Can sql servers link to other servers?

1139

---