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 |
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what do you understand by change data capture?
How you can minimize the deadlock situation?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
 Explain what is sql override for a source taLle in a mapping?
How will u test the stroded procedures and functions? difference between SP and Triggers
What do you think of this implementation? Can this be implemented better?
How to write a query with a right outer join in ms sql server?
What is the difference between grant and with grant while giving permissions to the user?
Do you know the capabilities of cursors?
What is data source in connection string?
What command do we use to rename a db, a table and a column?
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)