Answer / mohammad ali

DML

DML is abbreviation of Data Manipulation Language. It is
used to retrieve, store, modify, delete, insert and update
data in database.

Examples: SELECT, UPDATE, INSERT statements

DDL

DDL is abbreviation of Data Definition Language. It is used
to create and modify the structure of database objects in
database.

Examples: CREATE, ALTER, DROP statements

DCL

DCL is abbreviation of Data Control Language. It is used to
create roles, permissions, and referential integrity as well
it is used to control access to database by securing it.

Examples: GRANT, REVOKE statements

TCL

TCL is abbreviation of Transactional Control Language. It is
used to manage different transactions occurring within a
database.

Examples: COMMIT, ROLLBACK statements

what type of indexes physically sort data?

3 Answers  

---

what are user defined datatypes? : Sql server database administration

0 Answers  

---

How to create a simple stored procedure in ms sql server?

0 Answers  

---

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---