printable version

Test 2 Review B

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12]

Problem R2b.1.

A database for tracking student registration includes a table based on the following schemas.

students(idname)

Write an SQL query to accomplish each of the following.

a. Insert a new student with an ID of 54321 whose name is Luis Reasoner.

b. Change the name of the student whose ID is 97531 to be Alyssa P. Hacker.