Answer Posted / 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 is the difference between count(*) and count(1) ?

1026

---

What is ms sql server index?

1024

---

Introduction of rollup clause using sum and group by clause?

899

---

application server is slow what may be the problem

2165

---

what is a transaction and what are acid properties? : Sql server database administration

963

---

What happens if you add a new index to large table?

882

---

Why are you getting errors when creating a new odbc dsn?

1166

---

what is the primary use of the model database? : Sql server administration

962

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1988

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1069

---

How to find related tables in sql server?

871

---

How to convert numeric values to integers in ms sql server?

1007

---

How do I find sql server instance name?

914

---

What is a mixed extent?

950

---

How do you run a trace?

848

---