Which statement is true when a DROP TABLE command is executed on a - ProProfs Discuss
Topics
Products
Follow Us:

Which statement is true when a DROP TABLE command is executed on a table?

Which statement is true when a DROP TABLE command is executed on a table?

Change Image    Delete



A. Any pending transactions on the table are rolled back.
B. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.
C. The DROP TABLE command can be executed on a table on which there are pending transactions.
D. Only a DBA can execute the DROP TABLE command.

This question is part of ORACLE SQL
Asked by Vidya, Last updated: Jan 17, 2020

+ Answer
Request

3 Answers

C. Matz

Traveler and writer by profession.

C. Matz, College student, Graduation, Orlando

Answered Jul 18, 2019

There are two correct answers to this question, which are B. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed, and C. The DROP TABLE command can be executed on a table on which there are pending transactions.

The DROP TABLE command is used in the database management system called Oracle. This system is used to run online transactions, as well as data workloads and warehousing. Consultation for this database began in 1977, with the initial release happening two years later in 1979. Since then, several versions have been released and updated to fit the growing technological advancements and demands.

 

M. Krasinski

M. Krasinski, Content Writer, Columbus

Answered Sep 11, 2018

The drop table command is used to delete a table and all rows within the table. To delete an entire table including all its rows, issue the drop table command followed by the table name. Drop table is different from deleting all of the records in the table.

Dropping a table invalidates dependent object privilege on the table. A table can be dropped with a drop table statement. Also, when a table is dropped, any object that depends on the table is affected.

 

John Smith

John Smith

Answered Jun 12, 2017

The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.

The DROP command was designed for eliminating entire tables and users should be careful when using the drop command.

 

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.