Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
What needs correcting in the statement below to make it a valid UPDATE statement?
UPDATE titles SET t.ytd_sales = t.ytd_sales + s.qty FROM titles t, sales s WHERE t.title_id = s.title_id AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)
Remove the t from t.ytd_sales
You cannot use the FROM keyword in an UPDATE statement
You cannot use sub query in an UPDATE statement
There is nothing wrong with this SQL statement
That was the correct answer, well done!
Sorry, that was the wrong answer
A table alias (t) specified in a FROM clause cannot be used as a qualifier in SET column_name.
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2018
All rights reserved