View the exhibit and examine the data in ORDERS_MASTERand MONTHLY_ORDERStables.

Evaluate the following MERGEstatement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?

• A.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2, 3 and 4.
• B.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 4.
• C.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 3.
• D.The ORDERS_MASTERtable would contain the ORDER_IDs1 and 2.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.

Evaluate the following MERGE statement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total);
What would be the outcome of the above statement?

• A.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.
• B.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 4.
• C.The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 3.
• D.The ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.)

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

• A.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B.SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101);
• C.SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);
• D.SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM orders WHERE customer_id = 101);

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

Which SQL statement would retrieve from the table the number of products having LIST_PRICEas NULL?
SELECT COUNT (DISTINCT list_price)

• A.FROM product_information
  WHERE list_price is NULL
  SELECT COUNT (NVL(list_price, 0))
• B.FROM product_information
  WHERE list_price i= NULL
  SELECT COUNT (list_price)
• C.FROM product_information
  WHERE list_price is NULL
  SELECT COUNT (list_price)
• D.FROM product_information
  WHERE list_price is NULL

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.) Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
• B.The FIRST_NAME column would be dropped provided it does not contain any data.
• C.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.
• D.The FIRST_NAME column would be dropped provided at least one column remains in the table.

Comment: *

Name: *

Email: *

Verification: *