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?

Home / Programming MCQs / MySQL MCQs / Question

Jatin Dubey • 3.78K 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';

(D) None of these

Correct answer: Option(A)

MySQL 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

Related MCQs on MySQL

Which of the following is not the SQL Comparison Operator?

PL/SQL stored procedures move application code from the server to the client.

What will be the output of the following query:Select round(59999.99,-2);

How many files does each end of a client/server connection including SSL support use to set up secure communications?

In MySQL, identifier names can start with a digit.

Which of the following is TRUE about TCL?

Which of the following is an illegal unquoted identifier name?

What is the precision of BIGINT?

SQL has the advantage of?

For which of the following are triggers not supported?

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?

Explanation by: Jatin Dubey

Discusssion

Related MCQs on MySQL

Learn All MySQL MCQs