Multiple Choice
Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table
A) UPDATE Customer Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
B) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
C) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE Name = 'Gregory Adams'
D) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462'
Correct Answer:
Verified
Correct Answer:
Verified
Q1: Based on the table below, insert the
Q2: When you execute a rollback:<br>A) the temporary
Q3: Microsoft Access is an example of a:<br>A)Heavyweight
Q9: Which SQL command(s) modify the data in
Q10: The following command will compile a Java
Q13: If you encounter an error during updating
Q33: The acronym JDBC stands for _:<br>A)Joint Data
Q51: What will the following command do?<br>java -classpath
Q69: What does the execute method return?<br>A)ResultSet<br>B)Query<br>C)RecordSet<br>D)boolean
Q74: The _ class has a next method