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
How to configure and test odbc dsn settings?
Which is the main third-party tool used in sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What does <> symbol mean?
Define ACID properties in a Database?
What does set rowcount do?
What is transact-sql ddl trigger?
‘Order by’ is not allowed in a view how can you sort information from a view?
Difference between report and query parameter.
Is it possible to call a stored procedure within a stored procedure?
Find columns used in stored procedure?
How do you use a subquery to find records that exist in one table and do not exist in another?
Explain primary key in sql server?
What is the difference between dataadapter and datareader?
Explain the properties of a relational table?