A database administrator finds that a table is not needed in a relational database. Which of the following commands is used to completely remove the table and its data?

Prepare for the CompTIA ITF+ Exam with our interactive quiz, featuring multiple choice questions designed to enhance your understanding of IT fundamentals. Each question is supported by hints and explanations to ensure you grasp the material effectively. Ace your certification with confidence!

The DELETE command is used to remove specific data or rows from a table in a relational database. However, this does not completely remove the table itself. The UPDATE command is used to modify existing data in a table. The SELECT command is used to retrieve data from a table. In order to completely remove a table and its data from a relational database, the DROP command is used. This will remove the entire table and its contents permanently from the database.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy