Question

1) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Nick' to 'Cuba' for the 'Last Name' attribute in the table 'Vendors'

A. UPDATE VENDORS SET LAST_NAME='CUBA' WHERE LAST_NAME=NICK

B.INSERT INTO LAST_NAME VALUES("NICK");

C.INSERT INTO 'NICK' VALUES('VENDORS');

D. INSERT INTO VENDORS WHERE LAST_NAME="NICK"

2) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Gary' to 'Jada' for the 'Style' attribute in the table 'Invoice_Line'

A. INSERT INTO STYLE VALUES("GARY");

B.UPDATE INVOICE_LINE SET STYLE ='JADA' WHERE STYLE='GARY'

C. INSERT INTO 'GARY' VALUES('INVOICE_LINE');

D.INSERT INTO INVOICE_LINE VALUES('GARY')

E. INSERT INTO INVOICE_LINE WHERE STYLE="GARY"

3)Write or select the correct SQL statement that satisfies the following case: Change record with value '42' to '40' for the 'Quantity' attribute in the table 'Invoice_Line'

4)Write or select the correct SQL statement that satisfies the following case: Change record with value '38757' to '77503' for the 'Balance Due' attribute in the table 'Invoice'

A. INSERT INTO INVOICE WHERE BALANCE_DUE='38757'

B. INSERT INTO 38757 VALUES ('INVOICE');

C.INSERT INTO INVOICE VALUES(38757')

5) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Atmos Energy Corporation' to 'Interstate Bakeries Corporation' for the 'Company Name' attribute in the table 'Contacts'

A.UPDATE CONTACTS SET COMPANY_NAME='INTERSTATE BAKERIES CORPORATION 'WHERE COMPANY_NAME='ATOMS ENERGY CORPORATION';

B. INSERT INTO CONTACTS WHERE COMPANY_NAME="ATOMS ENERGY CORPORATION"

C. INSERT INTO CONTACTS VALUES('ATOMS ENERGY CORPORATION")

D. INSERT INTO COMPANY_NAME VALUES ("ATOMS ENERGY CORPORATION");

5) Write or select the correct SQL statement that satisfies the following case: Change record with value '34516' to '63525' for the 'Balance Due' attribute in the table 'Invoice'

A.INSERT INTO 34516 VALUES('INVOICE');

B. INSERT INTO INVOICE WHERE BALANCE_DUE='34516'

C. UPDATE INVOICE SET BALANCE_DUE=63525 WHERE

6) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Jodie' to 'Mcqueen' for the 'First Name' attribute in the table 'Vendors'

A.UPDATE VENDORS SET FIRST_NAME='MCQUEEN' WHERE FIRST_NAME='JODIE';

B. INSERT INTO VENDORS VALUES('JODIE")

C. INSERT INTO VENDORS WHERE FIRST_NAME="JODIE"

D. INSERT INTO 'JODIE' VALUES('VENDORS');

E. INSERT INTO FIRST_NAME VALUES('JODIE");

7) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Dustin' to 'Nick' for the 'Last Name' attribute in the table 'Customer'

A. INSERT INTO CUSTOMER WHERE LAST_NAME="DUSTIN"

B.INSERT INTO LAST_NAME VALUES('DUSTIN')

C.UPDATE CUSTOMER SET LAST_NAME='NICK' WHERE LAST_NAME='DUSTIN';

8)Write or select the correct SQL statement that satisfies the following case: Change record with value '33' to '19' for the 'Height' attribute in the table 'Contacts'

A. UPDATE CONTACTS SET HEIGHT=19 WHERE HEIGHT=33;

B. INSERT INTO HEIGHT VALUES('33')

C. INSERT INTO 33 VALUES('CONTACTS');

Please help here are some of the answers to the questions, but it's not all of them

Answer 1

Answer 1:

None of the provided options are correct.

Option B, C and D are incorrect as they are inserting the data into the table

Option A is incorrect because inverted commas ( ' ) are missing in the statement LAST_NAME=NICK

The correct sql query is :  UPDATE VENDORS SET LAST_NAME='CUBA' WHERE LAST_NAME='NICK'

Answer 2:

The correct option is B. UPDATE INVOICE_LINE SET STYLE ='JADA' WHERE STYLE='GARY'

Options A, C, D, E are incorrect because they are inserting the data into the table whereas the requirement is to update the data

Answer 3:

UPDATE INVOICE_LINE SET QUANTITY=40 WHERE QUANTITY=42

Answer 4:

None of the options provided are correct as they are inserting the data but the requirement is to update

The correct sql statement is UPDATE INVOICE SET BALANCE_DUE=77503 WHERE BALANCE_DUE=38757