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
Q21: All database URLs have the format:
A)jdbc:subprotocol:driver-specific data
B)jdbc/subprotocol/driver/data
C)oracle.jdbc.driver.OracleDriver
D)c:\jdk1.7.0\db\lib\driver.jar
Q31: What should be on the class path
Q32: What should the database.properties file contain so
Q34: Which SQL command(s) modify the data in
Q35: An example of a lightweight database is:
A)Oracle
B)MS
Q39: What is one reason why you need
Q40: The _ symbol in the query string
Q57: Which Java statement connects to a database
Q71: If you encounter an error during updating
Q75: The _ class has a next method
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents