What are the different types of queries?



What are the different types of queries?..

Answer / 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

More SQL Server Interview Questions

How does recursive cte works in sql server?

0 Answers  


What are ddl triggers and types of ddl trigger?

0 Answers  


What is an expression in ms sql server?

0 Answers  


How to update existing rows in a table?

1 Answers  


Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  






Can we take the full database backup in log shipping?

0 Answers  


What is the difference between drop table and truncate table?

0 Answers  


How to receive returning result from a query?

0 Answers  


What are the differences between substr and charindex in sql server.

0 Answers  


How to find out the list schema name and table name for the database?

0 Answers  


What are the two modes of authentication in sql server?

0 Answers  


What are unicode character string data types in ms sql server?

0 Answers  


Categories