What Is the Difference Between Deleting All Records from a Table

question 75

Multiple Choice

What is the difference between deleting all records from a table and truncating the table?

• A)Deleting is faster
• B)Truncating does not save roll back information while delete does
• C)Only a DBA can truncate,anyone can delete
• D)Delete does not save roll back information while truncate does

---

Definitions:

Digital Assistant

A software agent that can perform tasks or services for an individual based on commands or questions.

Search Engine Optimization

The practice of increasing the quantity and quality of traffic to a website through organic search engine results.

Online Shopping Demographic

The characteristics of the population segment that engages in purchasing goods and services via the internet, including age, gender, income, and preferences.

Millennials

A generational cohort following Generation X, typically defined as people born from the early 1980s to the late 1990s.