Answer Posted / anindya basu
The different types of queries are:
a. DDL- e.g. Create, Alter, Rename, Drop, Truncate etc.
b. DML - e,g, Insert, Update, and De;e
c. DCL - Grant, Revoke etc.
d. TCL - Begin Tran, Commit Tran, Rollback Tran
e. DQL - Select
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What language is sql server written in?
What is dml command?
Tell me what are cursors and when they are useful?
How do we synchronize On-Premise SQL server with SQL Azure?
between cast and convert which function would you prefer and why?
What information is maintained within the msdb database?
Can we use where clause with group by?
What is partition index in sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Explain what are the restrictions while creating batches in sql server?
Do you know what is similarity and difference between truncate and delete in sql?
Can multiple columns be used in sql group by clause in ms sql server?
Can a database be shrunk to 0 bytes, if not, why?
What are the new data types are introduced in sql 2000?
What is an inner join?