Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How can we write or define DDL statements in Sql server and
DML statements?

Question Posted / arijit bhawal

Answers were Sorted based on User's Feedback



How can we write or define DDL statements in Sql server and DML statements?..

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"

Is This Answer Correct ?    5 Yes 0 No

How can we write or define DDL statements in Sql server and DML statements?..

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

Is This Answer Correct ?    3 Yes 0 No

How can we write or define DDL statements in Sql server and DML statements?..

Answer / raju vikram

Delete is DDL statement and Truncate is DML statement

Is This Answer Correct ?    3 Yes 8 No

Post New Answer

More SQL Server Interview Questions

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

What is log ldf?

0 Answers  

What are the commands used in DCL?

0 Answers  

How do I get to sql server configuration manager?

0 Answers  

How many ways to create table-valued functions?

0 Answers  

What is rtm version in sql server?

0 Answers  

Explain transaction server consistency?

0 Answers  

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

What are the two modes of authentication in sql server?

0 Answers  

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories