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

Explain the different index configurations a table can have?

0 Answers  

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

What are the encryption mechanisms in sql server?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

What are indexers?

0 Answers  

---

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

What is a function? Give some example?

3 Answers  

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

What is difference between index seek vs. Index scan?

0 Answers  

---

How will you know when statistics on a table are obsolete?

0 Answers  

---