rchQUESTION 4Exercise: Create a statement that will add the following row to the invoices table:115, 1, '9632534', '2018-08-05', 85.25, 2, '2018-08-25'IMPORTANT: Use the type of statement that will only add the data to the following columns, skipping all others:invoice_id, vendor_id, invoice_number, invoice_date, invoice_total, terms_id, invoice_due_dateQUESTION 5Exercise: Create ONE statement that will add the following TWO rows to the terms table. Again, one statement / oneexecution. Do not write two separate statements.Net due 120 days, 120Net due 150 days 150Click Save and Submit to save and submit. Click Save All Answers to save all answers.O Bia80

Please find the SQL query's for the questions in the below steps.

Exercise: Create a statement that will add the following row to the invoices table: 115, 1, '9632534', '2018-08-05', 85.25, 2, '2018-08-25 IMPORTANT: Use the type of statement that will only add the data to the following columns, skipping all others: invoice_id, vendor_id, invoice_number, invoice_date, invoice_total, terms_id, invoice_due_date

Exercise: Create a statement that will add the following row to the invoices table: 115, 1, '9632534', '2018-08-05', 85.25, 2, '2018-08-25 IMPORTANT: Use the type of statement that will only add the data to the following columns, skipping all others: invoice_id, vendor_id, invoice_number, invoice_date, invoice_total, terms_id, invoice_due_date

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 1MC: Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN...

See similar textbooks

Similar questions

Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. You can’t create empty tables—all tables must contain at least three rows of data. A table can contain a maximum of 1000 columns. The maximum length of a table name is 265 characters.
Which of the following commands removes all data from a table but leaves the tables structure intact? a. ALTER TABLE secustomerorders DROP UNUSED COLUMNS; b. TRUNCATE TABLE secustomerorders; c. DELETE TABLE secustomerorders; d. DROP TABLE secustomerorders;
Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.
Which object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the above
8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;
1. ID Last Name First Name Create the My Employee table with the following fields: Not Null Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) Userid Salary 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali 1 2 3 4 5 AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed 4. Select all the data in the table. Userid raptel bdancs bbiri cnewman aropebur I Salary 795 860 1100 750 1550
Question 1: Modify the select statement in this section to display the hire_date column in the format: January 10, 2012. (7-3) Question 2: Add a new row to a copy of the employees table, sec0703_employees. Set the hire date to show that the person was hired at 10:00 AM. (7-6) Question 3: assist me with a new sequence named seq0706_my_stuff. Set the beginning value to 100. (7-7) Question 4: Determine the current value of the sequence seq_sec0707. Then use its next three values to add new rows to the sec0707_sequence table. This table has only one column. It holds the value of the sequence number. (7-9) Question 5: Build an index on a copy of the departments table, sec0709_departments. Index the department_name field. (7-12) Question 6: Find information about the datatypes of all the columns of the l_foods table. (7-14) Question 7: Find out what indexes there are on the l_departments table. (7-16) Question 8: Find…
You have been instructed to add a new student information to the students table. Because the student is new, he has no marks before, you should not add an amount to the CGPA. The Students table contains these columns: Student_id NUMBER(10) Student_name VARCHAR2(30) Student phone NUMBER(10) CGPA NUMBER(2,2) Which INSERT statements will accomplish your objective? O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 ) O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' ) O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL ) O d. INSERT INTO students VALUES (365, 'Khalil',99554721) Which line of code has an error? 1. CREATE TABLE FRUITS VEGETABLES 2. FRUIT TYPE VARCHAR2, 3. FRUIT NAME CHAR (20), 4. QUANTITY NUMBER (4)); O a. 1 O b. 2 O c. 3
1. Create the My Employee table with the following fields: Not Null ID Last Name First Name Userid Salary 1 2 3 4 5 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed Userid raptel bdancs bbiri cnewman aropebur Salary 795 860 1100 750 1550 I 4. Select all the data in the table. 5. Change the Last Name of employee 4 to Turkish. 6. Change the Salary to 1000 for all employees with a salary less than 900
1- Create a NONGAME table with the following structure: Column Туpe Length Decimal Places Nulls Allowed? Description ITEM NUM CHAR Primary Key 4 No DESCRIPTION CHAR 30 ON HAND DECIMAL 4 CATEGORY CHAR 3 PRICE DECIMAL 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3- In the NONGAME table, change the description of item number DL51 to "Classic Train Set". 4- In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02). 5- Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. 6- Delete every item in the NONGAME table for which the category is PZL. 7- In the NONGAME table, change the category for item FD11 to null. 8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-hand value is a seven-digit…
With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write the mySQL statement that will insert the following PRODUCT into the table: PRODUCT_NUMBER: ‘67832’ DESCRIPTION: ‘KRAZY CAT CEREAL’ PURCHASE_DATE: 2023-11-14 CATEGORY: ‘CPG’ Write the mySQL statement that will insert that product but without a description.