Which single command performs this? You have decided to permanently - ProProfs Discuss
Topics
Products
Follow Us:

Which single command performs this?
You have decided to permanently remove all the data from the student table, and you need the table structure in the future.



A. DELETE * FROM student;
B. DROP TABLE student;
C. TRUNCATE TABLE student;
D. DROP TABLE student;

This question is part of ORACLE SQL
Asked by Karthicksugadev, Last updated: Jan 18, 2020

+ Answer
Request

2 Answers

John Adney

John Adney

Answered Oct 09, 2017

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?

 

John Smith

John Smith

Answered May 20, 2017

TRUNCATE TABLE student;
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.