Question: Which statement ( s ) is / are correct for adding two records to the customer table: INSERT INTO customer VALUES ( ' 9 9

Which statement(s) is/are correct for adding two records to the customer table:
INSERT INTO customer
VALUES
('999','Jane','Doe','456 Elm Ave.','Panama City','FL','32445',700.00,900.00,'12');
('888','Baby','Doe','789 Forest Ct.','Tallahassee','FL','32305',800.00,9500.00,'03'); INSERT INTO customer
(customer_number, last, first, street, city, state, zip_code, balance, credit_limit, slsrep_number)
VALUES ('999', 'Jane','Doe', '456 Elm Ave.', 'Panama City', 'FL','32445',700.00,900.00,'12');
('888','Baby','Doe','789 Forest Ct.','Tallahassee','FL','32305',800.00,9500.00,'03');
INSERT INTO customer
VALUES
('999','Jane','Doe','456 Elm Ave.','Panama City','FL','32445',700.00,900.00,'12'),
('888','Baby','Doe','789 Forest Ct.','Tallahassee','FL','32305',800.00,9500.00,'03');
INSERT INTO customer
(customer_number, last, first, street, city, state, zip_code, balance, credit_limit, slsrep_number)
VALUES
('999','Jane','Doe','456 Elm Ave.','Panama City','FL','32445',700.00,900.00,'12'),
('888','Baby','Doe','789 Forest Ct.','Tallahassee','FL','32305',800.00,9500.00,'03');

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 General Management Questions!

Q:

compose the necessary SQL statements to do the following tasks. 1 . create the following database table: book ( isbn , title, author, numberOfPages, releaseDate ) - Note: Do not create a database. 2...

Q:

What is wrong with this T-SQL statement? Select * from dbo.book where * in ('two towers','hello kitty'); The book titles are not in double quotes. You must use a column before the in keyword in, not...

Q:

Chapter 4: Implementation of stored procedure and trigger Create a new schema called Sampleaccounts. Follow the following steps: 1. Create Sampleaccounts database (or schema) 2. Create an Accounts...

Q:

Implementation/SQL Introduction: An assignment to make sure you get Postgres installed and can execute basic statements. The subject of the table you will work with is supply-chain management, though...

Q:

Introduction: An assignment to make sure you get Postgres installed and can execute basic statements. The subject of the table you will work with is supply-chain management, though we are focusing on...

Q:

Question 1 DELETE from Customer will: Group of answer choices a.)Delete all records from the Customer Table b.)Delete the Customer Database c.)Delete all tables from the Customer DB d.)Delete the...

Q:

Basics for the assignment 0. Necessary Style* (please see below) 1. Create the table T1 owned by dbo per the specs for the T1 table in the Auditing Example in Chapter 4. Create a table owned by dbo...

Q:

Creating Database objects: 1: Using the Data Definition Language statement, create new database named Company. 2: Create the tables Agents, Customers and Orders with the following columns. (Declare...

Q:

You have a view component named ProductsByCategoryViewComponent that is placed in the Components folder. Which folder should you put in the partial view that it creates? Question 1 options:...

Q:

Using MySQL syntax create and run the following SQL scripts for the problems listed below within the sales_co schema. A script needed to create the sales_co schema can be found on D2L named...

Q:

2. Paramount Lamps Company has an annual requirement per 1000 lamp bases with a set up cost of P10 per order and a 10 percent carrying charge of these items which are valued at P5.00 each. What is...

Q:

Your boss asks you to analyze options for the S&P 500. Based on your analysis you believe the S&P 500 offers a dividend yield of 1.90% over the next year, has implied volatility of 18% per annum, and...

Q:

A programmer is developing a presentation of a new ICT solution for a conference and needs to consider the audience. a Using examples, explain why presentations and ICT solutions have to take into...

Q:

Journalising end of year closing entrires Skate 'n' Surf began operations on 1 June, buying and selling surfboards, skateboards, wetsuits and the protective gear for skateboarding. The structure of...