View the Exhibit and examine the structure of the ORDERS table.

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 orders
  WHERE order_date > ALL
  (SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B.SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT order_date FROM orders WHERE customer_id = 101);
• C.SELECT order_id, order_date FROM orders
  WHERE order_date > IN
  (SELECT order_date FROM orders WHERE customer_id = 101);
• D.SELECT order_id, order_date FROM orders
  WHERE order_date >
  ANY
  (SELECT order_date FROM orders WHERE customer_id = 101);

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

• A.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
• B.The CUST_STATUS column would give an error.
• C.The CUST_CREDIT_LIMIT column would be able to store decimal values.
• D.The TRANS_VALIDITY column would give an error.
• E.The TRANS_VALIDITY column would have a maximum size of one character.
• F.The CUST_STATUS column would store exactly one character.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCT_INFORMATION table.

Which two tasks would require subqueries? (Choose two.)

• A.displaying all supplier IDs whose average list price is more than 500
• B.displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
• C.displaying all the products whose minimum list prices are more than average list price of products having the status orderable
• D.displaying the number of products whose list prices are more than the average list price
• E.displaying the minimum list price for each product status

Comment: *

Name: *

Email: *

Verification: *

Which two are true about virtual columns?

• A.They can be referenced in the set clause of an update statement as the name of the column To be updated.
• B.They can be referenced In the where clause of an update or debete statement.
• C.They can be indexed.
• D.They can be referenced in the column expression of another virtxial column.
• E.They cannot have a data type explicitly specified.

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: *