what is the difference between delete and truncate?
Answer Posted / venkatesh kumar.s
Truncate:The truncate command deletes the rows in the
table,but not the structure of the table.
Cmd-truncate table tablename;
Drop:The drop command will drop the table from the databases.
Cmd-drop table tablename;
Delete:The delete cmd removes tuples from a relation.It
includes where clause to select the tuples to be deleted.
Cmd-delete from tablenmae where attribute-name="value" or value;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Enlist the advantages of normalizing database.
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What are database functions?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What are the different types of database keys?
Explain database partitioning and its importance.
What does a database contain?
What do you mean by fill factor concept with respect to indexes?
What is database connection pool size?
What are the importance of database in banking?
What is a form used for in a database?
What are the four components of a database system?
Is sql a rdbms?
Differentiate between nested loop, hash loop and merge join.
How does a database partition work?