Ignoring any errors or warnings that may be issued, which values are now in the table?

In non-strict mode, assuming that the table city does not already exist and you execute the following sequence of commands: CREATE TABLE city (city_name CHAR(5)) INSERT INTO city (city_name) VALUES (‘NEW YORK’), (‘TOKYO’), (23+345), (‘LONDON’) — Ignoring any errors or warnings that may be issued, which values are now in the table?

In non-strict mode, assuming that the table city does not already exist and you execute the following sequence of commands: CREATE TABLE city (city_name CHAR(5)) INSERT INTO city (city_name) VALUES (‘NEW YORK’), (‘TOKYO’), (23+345), (‘LONDON’) — Ignoring any errors or warnings that may be issued, which values are now in the table?

A.
‘NEW YORK’, ‘TOKYO’, ’23+345′, ‘LONDON’

B.
‘NEW Y’, ‘TOKYO’, ’23+34′, ‘LONDO’

C.
‘NEW YORK’, ‘TOKYO’, ‘ ‘, ‘LONDON’

D.
‘NEW Y’, ‘TOKYO’, ‘368’, ‘LONDO’

E.
‘NEW YORK’, ‘TOKYO’, ‘368’, ‘LONDON’



Leave a Reply 0

Your email address will not be published. Required fields are marked *