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 is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---

How to verify a user name with sqlcmd tool?

0 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

How do I start sql server?

0 Answers  

---

How many null values we can have in a unique key field in sql server?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

What is lookup override?

0 Answers   Informatica,

---

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

---

Explain “not null constraint” in sql server?

0 Answers  

---