CompTIA ITF+ Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Study for the CompTIA ITF+ Exam. Enhance your tech literacy with multiple-choice questions and detailed explanations. Prepare thoroughly and succeed!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

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?

UPDATE
SELECT
DELETE
DROP

The correct answer is: DROP

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.