Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of queries?
- 1 Answers
- 1602 Views
- I also Faced
- E-Mail Answers
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 |
ow to bring suspect mode datbase online from scratch
What is the difference between clustered and a non-clustered index?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is triggers and stored procedures?
Equi join and non equi join is possible with sql server?
How do I create a partition table in sql server?
What is simple indexing method?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to use old values to define new values in update statements in ms sql server?
How use inner join in sql server?
Why use identity in sql server?
Can you explain the role of each service?
-
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)
