Martin and Mary ______ their baskets of seeds on a fence outside the village.A: tookB:

A.with…on

B.have…on

C.with…in

D.have…in

A.took  

B.rested  

C.threw  

D.stole

AL100 12-JAN-2000 15 1000009-MAR-101 40 800009-MAR-102 35 1250015-MAR-103 15 12000104 25-JUN-2000 15 6000105 18-JUL-2000 20 5000106 18-JUL-2000 35 7000107 21-JUL-2000 20 650004-AUG-108 10 8000CUSTOMERSCUST_ID CUST_NAME CITY10 Smith Los Angeles15 Bob San Francisco20 Martin Chicago25 Mary New York30 Rina Chicago35 Smith New York40 Linda New YorkWhich 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. SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name=‘Mating‘ AND ord _ date IN (‘18-JUL-2000‘,‘21-JUL-2000‘);

B. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = ‘MARTIN‘));

C. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = ‘Martin‘);

D. SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = ‘Martin‘);

100 15 1000009-MAR-101 40 800009-MAR-102 35 1250015-MAR-103 15 1200025-JUN-104 15 600018-JUL-105 20 5000106 18-JUL- 35 700021-JUL-107 20 650004-AUG-109 10 8000CUSTOMERSCUST_ID CUST_NAME CITY10 Smith Los Angeles15 Bob San Francisco20 Martin Chicago25 Mary New York30 Rina Chicago35 Smith New York40 Lind New YorkEvaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed？（）

A. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000

B. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000

C. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000

D. The query fails because the subquery returns more than one row.

E. The query fails because the outer query and the inner query are using different tables.

A.Martin Fowler

B.Doug cutting

C.Martin Elliiot Zuckerberg

D.Kent Beck

A.Martin Fowler

B.Kent Beck

C.Doug cutting

A.Martin Fowler

B.Doug cutting

C.Martin Elliiot Zuckerberg

D.Kent Beck

A.Feret径＞投影圆当量径＞Martin径

B.Feret径＞Martin径＞投影圆当量径

C.Martin径＞投影圆当量径＞Feret径

D.Martin径＞Feret径＞投影圆当量径

A.Martin Luther

B.Martin Luther King

C.John Calvin

D.The English King Henry VIII