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

Will count(column) include columns with null values in its count?

0 Answers  

How many index keys possible for a table

6 Answers  

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

What are the recovery models for a database?

0 Answers  

What is de-normalization and when do you do it?

3 Answers  

What is default constraint in ms sql server?

0 Answers  

What are commonly used odbc functions in php?

0 Answers  

Do you know the cursor types?

0 Answers  

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

Explain the first normal form(1nf)?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories