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

explain how to create a new schema in a database? : Sql server database administration

1108

---

What command must you use to include the not null constraint after a table has already been created?

1149

---

What are views used for?

1014

---

Can the “if update (colname)” statement be used in a delete trigger?

990

---

Write an sql query to find first weekday of the month?

920

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1041

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4386

---

Explain what are various ways to enhance the ssrs report?

1044

---

How to make a remote connection in a database?

977

---

What is an index in sql?

1006

---

What is named query? : sql server analysis services, ssas

967

---

Mention the differences between sql server and mysql.

1016

---

List out the difference between union and union all in sql server?

990

---

What xml support does the sql server extend?

1013

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

978

---