Answer Posted / mohan kumar.a

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

How to create user defined functions with parameters?

1298

---

What are the two authentication modes in sql server?

1170

---

What is thr feature of change data capture?

1033

---

What is Service Broker in sql server 2012?

1074

---

What do you understand by a stored procedure?

1153

---

How many replicas are maintained for each SQL Azure database?

144

---

How to count rows with the count(*) function in ms sql server?

1060

---

How do you improve the performance of a SQL Azure Database?

137

---

Can a table be moved to different filegroup?

1025

---

What is resource db in sql server?

1058

---

What is a field in a table?

1075

---

What do you mean by an execution plan? Why is it used? How would you view it?

983

---

Explain boyce and codd normal form(bcnf)?

1015

---

what information is maintained within the msdb database? : Sql server administration

1017

---

What are different types of subquery?

1308

---