第1题:
TheINV_HISTORYtableiscreatedusingthecommand:
SQL>CREATETABLEINV_HISTORY(inv_noNUMBER(3),inv_dateDATE,inv_amtNUMBER(10,2))partitionbyrange(inv_date)interval(numtoyminterval(1,’month’))(partitionp0
valueslessthan(to_date(’01-01-2005’,’dd-mm-yyyy’)),partitionp1valueslessthan(to_date(’01-01-2006’,’dd-mm-yyyy’)));
ThefollowingdatahasbeeninsertedintotheINV_HISTORYtable:
INV_NOINV_DATEINV_AMT130-dec-20041000230-dec-2005200031-feb-2006300041-mar-2006400051-apr-20065000
Youwouldliketostorethedatabelongingtotheyear2006inasinglepartitionandissuethe command:
SQL>ALTERTABLEinv_historyMERGEPARTITIONS
FOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)),FOR(TO_DATE(’15-apr-2006’))INTOPARTITIONsys_py;
Whatwouldbetheoutcomeofthiscommand?()
第2题:
Advance freight must ______ to the Shipowner even if the goods are lost (by excepted perils) before payment,where they are lost after the due date of payment; nor is it recoverable if the goods are so lost after payment.
A.pay
B.be paying
C.have paid
D.be paid
第3题:
听力原文:From an early date bankers have made a charge for the services which they provide for their customers.
(9)
A.From an early date the banker have charged a commission for their services.
B.From an early date the banker has an obligation to serve the customers.
C.From an early date the customers have charged a commission.
D.From an early date the customer has an obligation to serve the banker.
第4题:
第5题:
第6题:
The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?()
A.TRIG_A
B.TRIG_B
C.TRIG_C
D.TRIG_D
第7题:
第8题:
We enclose a cheque for US $2000() payment of all commissions due ()you up to date.
A、into,against
B、in,to
C、for,to
D、on,to
第9题:
第10题: