Which three are true about the MERGE statement?

• A.It can combine rows from multiple tables conditionally to insert into a single table.
• B.It can use subqueries to produce source rows.
• C.It can merge rows only from tables.
• D.It can update, insert, or delete rows conditionally in multiple tables.
• E.It can update the same row of the target table multiple times.
• F.It can use views to produce source rows.

Comment: *

Name: *

Email: *

Verification: *

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.

Which set operator generates the required output?

• A.INTERSECT
• B.UNION
• C.PLUS
• D.MINUS
• E.SUBTRACT

Comment: *

Name: *

Email: *

Verification: *

Which two are true about global temporary tables?

• A.If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.
• B.They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.
• C.Backup and recovery operations are available for these tables.
• D.Their data is always stored in the default temporary tablespace of the user who created them.
• E.Indexes can be created on them.
• F.If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATE VIEW statement would create the views successfully?

• A.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  ||"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_dateWHITH CHECK OPTION;
• B.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;
• C.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;
• D.CREATE OR REPLACE VIEW ord_vu (order_id, order_date)AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PROMTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used?

• A.SELECT promo_cost, | pxomo_category FROM promotions ORDER BY 1;
• B.SELECT promo_category, DISTINCT promo_cost PROM promotions ORDER BY 2:
• C.SELECT DISTINCT promo_cost ||' in' II DISTINCT promo_category FROM promotions ORDER BY 1;
• D.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• E.SELECT DISTINCT promo_category ||'has'|| promo_cost AS COSTS FROM promotions ORDER BY 1;

Comment: *

Name: *

Email: *

Verification: *