DELETE, TRUNCATE or DROP?
QuizMediumAsked in: Accenture
Before a test run you must empty a large log table. The table and its structure must stay, you need no WHERE condition, and it should be fast. Which statement fits best?
- TRUNCATE TABLE logs
- DELETE FROM logs
- DROP TABLE logs
- ALTER TABLE logs
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.