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 what is the difference between a local and a global temporary table?

0 Answers  

---

Where is localdb stored?

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

What are the properties of the transactions?

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

Define compound operators?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

How to create a stored procedure with a statement block in ms sql server?

0 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---