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 mean by candidate key?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

what is maximum size of temp db?

4 Answers   iSoft,

---

---

What is msdb database? : SQL Server Architecture

0 Answers  

---

Explain Trigger with an example?

2 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---