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 extended properties

0 Answers  

---

What is the usage of sign function?

0 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---

How do I view a procedure in sql server?

0 Answers  

---

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

How to use user defined functions in expressions?

0 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---