AMA University Answers
Login
Register
AMA OED
Courses
IT
IT-6202
Which of the following is the...
Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?
UPDATE TABLE STUDENTSSET STUD_ID = 01020564;WHERE LASTNAME = =E2=80=98REYES=E2=80=99;
UPDATE STUDENTSSET LASTNAME = =E2=80=98REYES=E2=80=99WHERE STUD_ID = 01020564;
Correct
UPDATE TABLE STUDENTSSET LASTNAME = =E2=80=98REYES=E2=80=99WHERE STUD_ID = 01020564;
UPDATE STUDENTSSET STUD_ID = 01020564;WHERELASTNAME = =E2=80=98REYES=E2=80=99;
Similar IT-6202 questions
Which of the following is the correct example of deleting all records in STUDENTS table;
Which of the following is the correct example of inserting new values to STUDENTS table?
Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all student...
Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and...
Which of the following is the correct example inserting a new value to STUDENTS table that will only...
Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STU...