Home / Programming MCQs / MySQL MCQs / Question

J

Jatin Dubey • 3.72K Points
Extraordinary 

Q. Suppose you have two columns named student_name and student_department inside table student_details and you are asked to update the value of these two columns where ID=4 then what statement you will write?

(A) UPDATE student_details SET Student_name="ram", Student_department='Chemical' WHERE ID='4';
(B) UPDATE table student_details SET column_name Student_name="ram", Student_department='Chemical' WHERE ID='4';
(C) UPDATE student_details SET Student_name="ram" and Student_department='Chemical' WHERE ID='4';
(D) None of these

Correct answer: Option(A)

MySQL Share
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share
Explanation by: Jatin Dubey 
According to the given situation we will write,

UPDATE student_details SET Student_name="ram", Student_department='Chemical' WHERE ID='4';

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

Which option is used to specify to the server the IP number of the server host on which the server should listen?

Which of the following is the feature(s) of SQL Auto Increment?

Which parameter acts like a constant inside the subprogram?

Which property determines whether a database object is case sensitive?

Arrays in other languages become varrays in PL/SQL.

A view can be deleted using the command __________

Which statement can produce the same output as ‘SHOW COLUMNS’?

If no database has been selected, specifying a database qualifier is necessary.

What is the maximum number of triggers that can apply to a single table?

For which of these storage engines are configuration options always built?

Learn All MySQL MCQs