Home / Programming MCQs / MySQL MCQs / Question
J
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?
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
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?
Discusssion
Login to discuss.