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);

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);

相关考题：

Your little girl is becoming very rude. You ________ scold her. A.mayB.canC.ought toD.need
查看答案
May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t
查看答案
You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）A. Ensure that the child column and the parent column have the same names.B. Ensure that the child table and the parent table have the same names.C. Ensure that the child column and the parent column have the same data types.D. Ensure that each row in the child table has a corresponding row in the parent table.E. Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
查看答案
AJSPpageneedstoinstantiateaJavaBeantobeusedbyonlythatpage.Whichtwojsp:useBeanattributesmustbeusedtoaccessthisattributeintheJSPpage?() A.idB.typeC.nameD.classE.scopeF.create
查看答案
You’reanetworkadministerandyouissuethecommand(showport3／1)onanEthernetport.Toyoursurpriseyounoticeanon－zeroentryinthe’Giants’column.Whatcouldbethecauseofthis?() A.IEEE802.1QB.IEEE802.10C.MisconfiguredNICD.UserconfigurationE.Alloftheabove
查看答案
命令在当前设计中创建一个时钟。A．create_clockB．create clockC．clock_nameD．clock name
查看答案
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）A．Create_Table，Alter_Table，Drop_TableB．Create_View，Alter_View，Drop_ViewC．Create_Procedure，Alter_Procedure，Drop_ProcedureD．Rollback
查看答案
16、MySQL数据库中，通常将用户写入对应的权限表来控制访问权限的，以下属于用户权限得选项（）。A．UserB．dbC．table_privD．columns_priv
查看答案
如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？A．create tableB．create any tableC．create all tableD．create * table
查看答案
设置多列布局的属性值为（）。A．columns-widthB．column-countC．column-gapD．column-rule
查看答案
热门标签