Crucial Exams

CompTIA ITF+ FC0-U61 (V5) Practice Question

In a relational database that uses SQL, what is the primary effect of executing the statement:

DROP TABLE Employees;

?

  • It permanently removes the table definition and all of its data from the database.

  • It deletes only the rows that satisfy a WHERE clause condition, leaving the remaining rows and the structure intact.

  • It removes all rows from the table but preserves the table structure so it can be reused.

  • It renames the table and resets its identity column without deleting any data.

CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot