Which two statements are true regarding savepoints?

Which two statements are true regarding savepoints? (Choose two.) A. Savepoints are effective only for COMMIT. B. Savepoints may be used to ROLLBACK. C. Savepoints can be used for only DML statements. D. Savepoints are effective for both COMMIT and ROLLBACK. E. Savepoints can be used for both DML and DDL statements. Show Answer

Read More

Which statement is true regarding transactions?

Which statement is true regarding transactions? (Choose all that apply.) A. A transaction can consist only of a set of DML and DDL statements. B. A part or an entire transaction can be undone by using ROLLBACK command. C. A transaction consists of a set of DML or DCL statements. D. A part or an […]

Read More

Which statement is true regarding the execution of the above UPDATE statement?

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’ ANDcredit_limit = 600);Which statement is true regarding the execution of the above UPDATE statement? A. It would not execute because two […]

Read More

What is the outcome?

View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables.SALE_VW is a view created using the following command:SQL>CREATE VIEW sale_vw ASSELECT prod_id, SUM(quantity_sold) QTY_SOLDFROM sales GROUP BY prod_id;You issue the following command to add a row to the SALE_SUMMARY table:SQL>INSERT INTO sale_summarySELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN productsUSING (prod_id) WHERE […]

Read More

Which statement is true regarding the execution of the above statement?

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 true regarding the execution of the above statement? A. The statement will execute […]

Read More

Which two statements are true regarding the outcome of the above query?

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables. Evaluate the following SQL command:SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limitFROM orders o JOIN customers cUSING (customer_id)WHERE o.order_total > c.credit_limitFOR UPDATEORDER BY o.order_id;Which two statements are true regarding the outcome of the above query? (Choose two.) A. It locks all the rows that […]

Read More

What would be the outcome of the above SQL statement?

View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.Evaluate the following SQL statement:SQL> SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promotionsWHERE promo_cost < ALL(SELECT MAX(promo_cost) FROM promotionsGROUP BY (promo_end_datepromo_begin_date)));What would be the outcome of the above SQL statement? A. It displays prod IDs in the promo with the lowest […]

Read More

Which query would give the correct output?

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 listprice is less than half the maximum in each category.Which query would give the correct output? A. SELECT prod_category, avg(prod_list_price) FROM products GROUP BY prod_category HAVING avg(prod_list_price) […]

Read More