In which order can a resume be organized?
第1题:
You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number data type3. an ORDER_STATUS column that contains a character data type4. aDATE_ORDERED column to contain the date the order was placed.When a row is inserted into the table, if no value is provided when the order was placed, today‘s date should be used instead.Which statement accomplishes this? ()
A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
第2题:
A.onlythelow-order23bitsoftheMACaddressareusedtomapIPaddresses
B.onlythelow-order24bitsoftheMACaddressareusedtomapIPaddresses
C.onlythehigh-order23bitsoftheMACaddressareusedtomapIPaddresses
D.onlythelow-order23bitsoftheIPaddressareusedtomapMACaddresses
E.the0x01004fMACaddressprefixisusedformappingIPaddressestoMACaddresses
F.the0x01005eMACaddressprefixisusedformappingIPaddressestoMACaddresses
第3题:
4、在本节中,测试类里创建了Person类的对象p,使用该对象调用order()方法正确的是()。
A.p.order(new Car());
B.p.order(new Truck());
C.p.order(Car myCar);
D.p.order(Truck myTruck);
第4题:
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;
第5题:
第6题:
在本节中,测试类里创建了Person类的对象p,使用该对象调用order()方法正确的是()。
A.p.order(new Car());
B.p.order(new Truck());
C.p.order(Car myCar);
D.p.order(Truck myTruck);