GeekInterview.com
Series: Subject: Topic:
Question: 205 of 377

truncate command in oracle is DDL command or DML command ? give the answer with descirptive reason which is and why?

Asked by: nareshgupta12 | Member Since Jan-2007 | Asked on: Jan 8th, 2007

View all questions by nareshgupta12   View all answers by nareshgupta12

Showing Answers 1 - 12 of 12 Answers

The truncate command is neither DDL statement or DML statement but it is A TCL statement . TCL- Transcation control statement. COMMIT, ROLLBACK,SAVEPOINT,TRUNCATE all are transcation control statement

  
Login to rate this answer.
santosh_yadein

Answered On : Jan 23rd, 2007

View all answers by santosh_yadein

Truncate commad is DDL statement ,we can`t after rolledback truncate command is executed.

  
Login to rate this answer.
Praveen reddy.P

Answered On : Jan 31st, 2007

Truncate is a DDL statement

  
Login to rate this answer.
A.R.Anandhi

Answered On : Feb 17th, 2007

Truncate is a DDL Statement.Whereas Delete is a DML Statement.

  
Login to rate this answer.
A.R.Anandhi

Answered On : Feb 17th, 2007

Truncate is a DDLcommand.Whereas Delete is a DML Command.

  
Login to rate this answer.
sekhar

Answered On : Feb 25th, 2007

Truncate is DDL command . truncate means delete+commit. DDL commands are directly connecting to database. DML commands are  first connecting to memory cache. these are deferences between ddl and dml

  
Login to rate this answer.
mahi

Answered On : Sep 14th, 2007

Truncate command is a DDL statement.DDL ststements can't be rollback. Truncate statement can't be rollback.In DDL statement we can't use WHERE. In truncate also we can't use WHERE.DELETE is a DML statement we can rollback as well as we can use WHERE.

  
Login to rate this answer.
dipak2704

Answered On : Aug 27th, 2009

View all answers by dipak2704

Following are different types of SQL languageDQL - Data query language e.g. selectDDL - Data definition language e.g. create, alter, dropDML - Data manipulation language e.g. insert, update, deleteTCL - Transaction control language e.g commit, rollback, savepointDCL - Data control language e.g grant, revoke

  
Login to rate this answer.

Truncate is a DDL command.

  
Login to rate this answer.
asit

Answered On : Jun 9th, 2012

Truncate is a DDL command. Internally what it does is it drops the whole table and recreate the structure.

  
Login to rate this answer.
HARSHINI

Answered On : Jul 13th, 2012

TRUNCATE is a data definition language (DDL) command.Removes all rows from the table,leaving the table empty and the table structure intact.

  
Login to rate this answer.
Krishna G

Answered On : Mar 4th, 2013

Truncate is a DDL command.You can not rollback the data once you done truncate command

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.