单选题Which business flow is used for activities starting from customer registration, to setting up ofproduct catalogs and targeted storefronts, and finally to capturing of the order?（）A Click to OrderB Order to CashC Campaign to OrderD Contract to Renewal

The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

XYZ Corp. is in the business of manufacturing cosmetics. It obtains and pays for raw materials.Which business flow in Oracle E-Business Suite would map to the above activities of obtainingand paying for raw materials?（）

A.Order to Cash

B.Procure to Pay

C.Forecast to Plan

D.Demand to Build

E.Contract to Renewal

Reference is() our purchase order or contract dated July, 1999.

A、 made to

B、made of

C、made up

D、made up of

Revenue should be recognized when( )

A. cash is received

B. the service is performed

C. the customer places an order

D. the customer charges an order

A.Click to Order

B.Order to Cash

C.Campaign to Order

D.Contract to Renewal

Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

A.

B.

C.

D.

对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句，其在被DBMS处理时，各子句的执序次序(43)。

A．SELECT—FROM—GROUP—WHERE—ORDER

B．FROM—SELECT—WHERE—GROUP—ORDER

C．FROM—WHERE—GROUP—SELECT—ORDER

D．SELECT—FROM—WHERE—GROUP—ORDER

对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为()

A.SELECT—FROM—GROUP—WHERE—ORDER

B.FROM——SELECT--WHERE——GROUP——ORDER

C.FROM——WHERE——GROUP——SELECT——ORDER

D.SELECT——FROM——WHERE——GROUP——ORDER