View the Exhibit; e xamine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked you to generate a report, which provides the weekly cost for each promotiondone to l date.Which query would achieve the required result?
View the Exhibit and examine the description for the PRODUCTS and SALES table.PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want toremove all the rows from the PRODUCTS table for which no sale was done for the last three years.Which is the valid DELETE […]
View the Exhibit and examine the description of SALES and PROMOTIONS tables.You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONStable has either blowout sale or everyday low price as values.Which DELETE statements are valid? (Choose all that apply.)
View the Exhibit and examine the description for the CUSTOMERS table. You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customer with the CUST_ID 2360. You want the value for the CUST_INCOME_LEVEL to have the same value as that of the customer with the CUST_ID 2560 […]
View the Exhibit and examine the structure of CUSTOMERS and SALES tables.Evaluate the following SQL statement:UPDATE (SELECT prod_id, cust_id, quantity_sold, time_idFROM sales)SET time_id = ’22-MAR-2007’WHERE cust_id = (SELECT cust_idFROM customersWHERE cust_last_name = ‘Roberts’ […]
View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, whereCUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?
View the exhibit and examine the description for the SALES and CHANNELS tables.You issued the following SQL statement to insert a row in the SALES table:INSERT INTO sales VALUES(23, 2300, SYSDATE, (SELECT channel_idFROM channelsWHERE channel_desc=’Direct Sales’), 12, 1, 500);Which statement is […]
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cust_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT […]
View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that havethe same data types and size as the corresponding columns in the CUSTOMERS table.Evaluate the following INSERT statement:INSERT INTO […]
View the Exhibit and examine the structure of the PRODUCTS tables. You want to generate a report that displays the average list price of product categories where the average list price is less than half the maximum in each category. Which query would give the correct output?