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 the class forname () does?

0 Answers  

---

What do you mean by tablesample?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

What is a cursor, index in sql?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

query processing

0 Answers  

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

What is difference between group by and having?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

Write an sql query to find first weekday of the month?

0 Answers  

---