Use app×
Ask a Question
QUIZARD
QUIZARD
JEE MAIN 2026 Crash Course
NEET 2026 Crash Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE

Which of the following statement is true?

← Prev Question Next Question →
0 votes
25.1k views
in Information Technology by (121k points)
closed by
Which of the following statement is true?

(a) DELETE does not free the space containing the table and TRUNCATE free the space containing the table

(b) Both DELETE and TRUNCATE free the space containing the table

(c) Both DELETE and TRUNCATE does not free the space containing the table

(d) DELETE free the space containing the table and TRUNCATE does not free the space containing the table
Challenge Your Friends with Exciting Quiz Games – Click to Play Now!

1 Answer

0 votes
by (120k points)
selected by
 
Best answer
Correct choice is (a) DELETE does not free the space containing the table and TRUNCATE free the space containing the table

The explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.
← Prev Question Next Question →

Find MCQs & Mock Test

  1. JEE Main 2026 Test Series
  2. NEET Test Series
  3. Class 12 Chapterwise MCQ Test
  4. Class 11 Chapterwise Practice Test
  5. Class 10 Chapterwise MCQ Test
  6. Class 9 Chapterwise MCQ Test
  7. Class 8 Chapterwise MCQ Test
  8. Class 7 Chapterwise MCQ Test

Related questions

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

User Contribution to Sarthaks eConnect
Managed by Sarthaks Digitizing India
...