网友您好, 请在下方输入框内输入要搜索的题目:
Evaluatethefollowingstatements:
CREATETABLEpurchase_orders(po_idNUMBER(4),
po_dateTIMESTAMP,supplier_idNUMBER(6),po_totalNUMBER(8,2),
CONSTRAINTorder_pkPRIMARYKEY(po_id))PARTITIONBYRANGE(po_date)
(PARTITIONQ1VALUESLESSTHAN(TO_DATE(?1-apr-2007?d-mon-yyyy?),PARTITIONQ2VALUESLESSTHAN
(TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITIONQ3VALUESLESSTHAN(TO_DATE(?1-oct-2007?d-mon-yyyy?),PARTITIONQ4VALUESLESSTHAN(TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATETABLEpurchase_order_items(po_idNUMBER(4)NOTNULL,product_idNUMBER(6)NOTNULL,unit_priceNUMBER(8,2),quantityNUMBER(8),CONSTRAINTpo_items_fkFOREIGNKEY
(po_id)REFERENCESpurchase_orders(po_id))PARTITIONBYREFERENCE(po_items_fk);
Whatarethetwoconsequencesoftheabovestatements?()
参考答案
更多 “ Evaluatethefollowingstatements:CREATETABLEpurchase_orders(po_idNUMBER(4),po_dateTIMESTAMP,supplier_idNUMBER(6),po_totalNUMBER(8,2),CONSTRAINTorder_pkPRIMARYKEY(po_id))PARTITIONBYRANGE(po_date)(PARTITIONQ1VALUESLESSTHAN(TO_DATE(?1-apr-2007?d-mon-yyyy?),PARTITIONQ2VALUESLESSTHAN(TO_DATE(?1-jul-2007?d-mon-yyyy?),PARTITIONQ3VALUESLESSTHAN(TO_DATE(?1-oct-2007?d-mon-yyyy?),PARTITIONQ4VALUESLESSTHAN(TO_DATE(?1-jan-2008?d-mon-yyyy?));CREATETABLEpurchase_order_items(po_idNUMBER(4)NOTNULL,product_idNUMBER(6)NOTNULL,unit_priceNUMBER(8,2),quantityNUMBER(8),CONSTRAINTpo_items_fkFOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id))PARTITIONBYREFERENCE(po_items_fk);Whatarethetwoconsequencesoftheabovestatements?() ” 相关考题
![瑞牛题库 章节练习 历年真题 模拟试卷](http://assets.51tk.com/51_sidebar_right_index.jpg)