CompTIA ITF+ FC0-U61 Practice Question

A manager at a retail company needs to adjust the price of an item in their inventory database due to a recent change in supplier costs. Using appropriate commands, how would they modify the existing price for this item without affecting any other records in the database?

  • By using a SELECT statement with the new price where the item ID matches the specific product.

  • By using an UPDATE statement to change the item's price where the item ID matches the specific product.

  • By using an INSERT statement with the new price for the item ID.

  • By deleting the item and adding it again with the new price.

CompTIA ITF+ FC0-U61
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.

Bash, the Crucial Exams Chat Bot
AI Bot