What is the difference between DELETE and TRUNCATE commands?
Question
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 2 )
1) Delete
– Delete is Data Manipulation Language command
-You can specify the tuple that you want to delete.
-DELETE command can have WHERE clause.
– DELETE command eliminate the tuples one-by-one.
– DELETE command acts slower as compared to TRUNCATE.
– DELETE command can be followed either by COMMIT or ROLLBACK.
2) Truncate
– Truncate is a Data Definition Language Command
– It deletes all the tuples from a relation.
– TRUNCATE command do not have WHERE clause.
– TRUNCATE delete the entire data page containing the tuples.
– TRUNCATE is faster as compared to DELETE.
– TRUNCATE command can’t be ROLL BACKED.
-Delete
It removes data Plus Table definition or table structure
-Truncate
It only removes data from table