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 |
what is the primary use of the model database? : Sql server administration
How to delete database objects with "drop" statements in ms sql server?
Write a query for primary key constraint with identity key word?
Can you please explain the difference between function and stored procedure?
How to create logins using windows Authentication mode?
What happens when transaction log is full?
What is the difference between count and distinct count?
What command is used to delete a table from the database in the sql server and how?
What is the STUFF function and how does it differ from the REPLACE function?
Can a table have 2 foreign keys?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
how to find number of columns in a table in sql server 2000 and 2005 also
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)