Question: You have a database table that contains the following columns: dbo.AddressInfo Columns StreetAddress (varchar(255), null) City (varchar(255), null) State (varchar(2), null) PostalCode (varchar(15), null) You

You have a database table that contains the
You have a database table that contains the following columns: dbo.AddressInfo Columns StreetAddress (varchar(255), null) City (varchar(255), null) State (varchar(2), null) PostalCode (varchar(15), null) You must insert the following record into the table: StreetAddress City State PostalCode 1234 Main Street Dallas TX 75201 Which two SQL statements can you use? (Choose 2.) O A. INSERT INTO AddressInfo ( [StreetAddress], [City], [State], [PostalCode]) VALUES ('1234 Main Street', 'Dallas' , 'TX' , '75201'); O B. UPDATE AddressInfo SET [StreetAddress] = '1234 Main Street', [City] = 'Dallas', [State] = 'TX', [PostalCode] = '75201' ; O C. INSERT INTO AddressInfo ('1234 Main Street', 'Dallas', 'TX', '75201') VALUES ( [StreetAddress], [City], [State], [PostalCode]); D. INSERT INTO AddressInfo VALUES ('1234 Main Street', 'Dallas', 'TX', '75201')

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!