Microsoft Azure Data Fundamentals DP-900 Practice Question
You have an Azure SQL Database that contains a table named Sales. The application developer asks you to change the Price column value for several existing rows where the ItemID equals 100. Which SQL statement type should you use to alter the existing row data?
The UPDATE statement modifies data that is already stored in one or more rows of a table. It allows you to set new values for specified columns while optionally restricting the rows to be changed with a WHERE clause. INSERT adds new rows, not alter existing ones; DELETE removes rows altogether; and CREATE TABLE defines a new table's structure but does not change the data within an existing table.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the purpose of the WHERE clause in an UPDATE statement?
Open an interactive chat with Bash
How is an INSERT statement different from an UPDATE statement?
Open an interactive chat with Bash
What happens if you execute an UPDATE statement without a WHERE clause?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .