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

Explain about extended stored procedure?

0 Answers  

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

mention different types of relationships in the dbms?

0 Answers  

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

Explain what is raid and what are different types of raid levels?

0 Answers  

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

Explain subquery and state its properties?

0 Answers  

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

How to create a view on an existing table in ms sql server?

0 Answers  

What are the elements of dbms?

0 Answers  

How will you decide the active and passive nodes?

0 Answers  

What is the query optimization statistics?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories