Answer / simran_8185@rediff.com

DDl is a data defination language means we are defining
like create is a DDL statement
Eg: create table Emp(name varchar(20),address varchar(40));

whereas DML is a Data Manipulation Language in which
updations are made like
update table Emp set name="Ravi" where name="Anil"

Answer / kalyana chakravarthy maddipati

DDl statements like Create, Alter, Drop and Truncate can't be Rollbacked and Committed implicitly where as DML statements like Insert, Update and Delete can be rollbacked. DML statements has to be comitted explicitly

Answer / raju vikram

Delete is DDL statement and Truncate is DML statement

Name the different type of indexes in sql?

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What is the use of @@spid?

0 Answers  

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

How do I find the size of a sql server database?

0 Answers  

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

what is differece between union and union all

6 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,

---

How to use order by with union operators in ms sql server?

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---