Question

34.
Considering the following tables:
Customers
Columns: customer_id (number, primary key), name (varchar), country_code
(varchar)
What SQL statement will insert new customer with name "New Customer who is
situated in Germany ('DE' ? ISO code for Germany) with customer_id 100?
a) INSERT INTO customers (customer_id, name, country code)
VALUE ("New Customer', 'DE', 100)
b) INSERT INTO customers (name, country code)
VALUE (100," New Customer', 'DE')
c) INSERT INTO customers (customer id, name, country code)
VALUE (100," New Customer', 'DE')
d) INSERT INTO customers (customer id, name, country code)​

Answer 1

Answer:

Explanation:

A