Oracle
1Z0-146 · Question #83
You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?
The correct answer is B. TRUNCATE TABLE student. See the full explanation below for the reasoning.
Question
You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?
Options
- ADROP TABLE student;
- BTRUNCATE TABLE student;
- CDELETE *
- DTRUNCATE TABLE student
- EDELETE *
How the community answered
(49 responses)- A4% (2)
- B78% (38)
- C12% (6)
- D2% (1)
- E4% (2)
Community Discussion
No community discussion yet for this question.