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 is dbcc?
What is a field in a table?
Explain the steps to create and execute a user-defined function in the sql server?
How to name query output columns in ms sql server?
What methods do you follow to protect from sql injection attack?
What is the Control Flow in SSIS
What is a partitioned view?
How to set the current database in ms sql server?
What are “lock” hints?
What do you understand by triggers?
How to make a column nullable?
Explain linked server in sql?
What is the use of keyword with encryption.
How to find the service pack installed? : sql server database administration
How do you make a trace?