> > >

Transact-SQL (T-SQL) MCQs

Which is the best approach to update the last name and email address of a student with ID 56295?

UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id='56295';

UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;

UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id=56295;

UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id='56295';

Answer

Correct Answer: UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Transact-SQL (T-SQL) MCQ Questions

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it