Question

Q.25 Examine the structure of the STUDENT table:STUD_ID NUMBER(3) primary keyNAME VARCHAR2(25) not null ADDRESS VARCHAR2(50)GRADUATION DATEWhich of the following statement will update graduation date of all the students from '01-May-2009'1.0 Update student set graduation='01-Jun-2009';2.0 Update student graduation='01-Jun-2009' where graduation='01-May-2009';3.0 Update student set graduation='01-Jun-2009' where graduation='01-May-2009'; 4. Update student set graduation='01-May-2009' where graduation='01-Jun-2009';to'01-Jun-2009'​

Answer 1

All the student records with a graduation date of '01-May-2009' will be updated to '01-Jun-2009'.

Explanation:

• The correct statement that will update the graduation date of all the students from '01-May-2009' to '01-Jun-2009' is option 3.0:
• Update student set graduation='01-Jun-2009' where graduation='01-May-2009';
• This statement follows the correct syntax for updating records in a table. It uses the "UPDATE" keyword followed by the table name "student". The "SET" keyword is used to specify the column to be updated, which is "graduation" in this case. The new value '01-Jun-2009' is assigned to the graduation column.
• The "WHERE" clause is used to specify the condition for updating the records. In this case, it specifies that only the records with a graduation date of '01-May-2009' should be updated.

• By executing this statement, all the student records with a graduation date of '01-May-2009' will be updated to '01-Jun-2009'.

For more such questions on graduation date:

https://brainly.in/question/1553162

#SPJ1