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 |
How you can minimize the deadlock situation?
How to avoid cursors?
3 Answers CarrizalSoft Technologies, HP,
Explain what is the difference between union and union all?
Which joins are sql server default?
Do you know what guidelines should be followed to help minimize deadlocks?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
How to find related tables in sql server?
What is scheduled job and how to create it?
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
what happens on checkpoint? : Sql server database administration
State the difference between union and union all?
What are scalar functions?
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)