QUIZ QUESTION What command would you use to add 1 to the rating of all movies in the movies table? UPDATE movies (rating
Posted: Fri Jul 01, 2022 5:39 am
QUESTION What command would you use to add 1 to the rating of all movies in the movies table? UPDATE movies (rating) VALUES (rating 1) UPDATE movies SET rating rating 1 UPDATE TABLE movies SET rating rating 1 UPDATE TABLE movies (rating) VALUES (rating 1)
QUIZ QUESTION What would the result of the following UPDATE be? UPDATE people SET first name UPPER(first_name); CHRUIT This would not update anything because there is no WHERE clause in the query This would update all rows because there is no WHERE clause in the query This would create a backup copy of the table with the updated data because there is no WHERE clause in the query
QUIZ QUIZ QUESTION What would the result of the following UPDATE be? UPDATE people SET first name UPPER(first_name); CHRUIT This would not update anything because there is no WHERE clause in the query This would update all rows because there is no WHERE clause in the query This would create a backup copy of the table with the updated data because there is no WHERE clause in the query