Question 15 (1 point) Which keyword is used to add records to tables? COPY INTO ADD INTO WRITE INTO INSERT INTO
Added by Monica P.
Close
Step 1
Step 1: The keyword used to add records to tables is **INSERT INTO**. Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 54 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Question 1: Use this table to answer questions 1.1 and 1.2. Invoices table. INVOICE_ID | VENDOR_ID | INVOICE_NUMBER | INVOICE_DATE | INVOICE_TOTAL | PAYMENT_TOTAL | CREDIT_TOTAL | TERMS_ID 1 | 34 | QP58872 | 25-FEB-14 | 116.54 | 116.54 | 0 | 4 2 | 34 | Q545443 | 14-MAR-14 | 1083.58 | 1083.58 | 0 | 4 3 | 110 | P-0608 | 11-APR-14 | 20551.18 | 0 | 1200 | 5 4 | 110 | P-0259 | 16-APR-14 | 26881.4 | 26881.4 | 0 | 3 5 | 81 | MABO1489 | 16-APR-14 | 936.93 | 936.93 | 0 | 3 6 | 122 | 989319-497 | 17-APR-14 | 2312.2 | 0 | 0 | 4 7 | 82 | C73-24 | 17-APR-14 | 600 | 600 | 0 | 2 8 | 122 | 989319-487 | 18-APR-14 | 1927.54 | 0 | 0 | 4 9 | 122 | 989319-477 | 19-APR-14 | 2184.11 | 2184.11 | 0 | 4 10 | 122 | 989319-467 | 24-APR-14 | 2318.03 | 2318.03 | 0 | 4 11 | 122 | 989319-457 | 24-APR-14 | 3813.33 | 3813.33 | 0 | 3 12 | 122 | 989319-447 | 24-APR-14 | 3689.99 | 3689.99 | 0 | 3 13 | 122 | 989319-437 | 24-APR-14 | 2765.36 | 2765.36 | 0 | 2 14 | 122 | 989319-427 | 25-APR-14 | 2115.81 | 2115.81 | 0 | 1 15 | 121 | 97/553B | 26-APR-14 | 313.55 | 0 | 0 | 4 1.2 Write a statement that creates the vendors table. Add 4 more rows to this table in addition to the primary key. 1.3 Insert the 15 rows as indicated on the invoices table.
Madhur L.
Which query allows addition, deletion, updating, and appending operators on data?
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD