Examinethecommandthatisusedtocreateatable：SQL>CREATETABLEorders（oidNUMBER（6）PRIMARYKEY，odateDATE，ccodeNUMBER（6），oamtNUMBER（10，2））TABLESPACEusers；Whichtwostatementsaretrueabouttheeffectoftheabovecommand（）A.ACHECKconstraintiscreatedontheOIDcolumn.B.ANOTNULL

题目

Examinethecommandthatisusedtocreateatable：SQL>CREATETABLEorders（oidNUMBER（6）PRIMARYKEY，odateDATE，ccodeNUMBER（6），oamtNUMBER（10，2））TABLESPACEusers；Whichtwostatementsaretrueabouttheeffectoftheabovecommand（）

A.ACHECKconstraintiscreatedontheOIDcolumn.

B.ANOTNULLconstraintiscreatedontheOIDcolumn.

C.TheORDERStableistheonlyobjectcreatedintheUSERStablespace.

D.TheORDERStableandauniqueindexarecreatedintheUSERStablespace.

E.TheORDERStableiscreatedintheUSERStablespaceandauniqueindexiscreatedontheOIDcolumnintheSYSTEMtablespace.

相似考题

1.Which statement accomplish 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 NUMBER (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.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);

3.Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN (‘CREDIT‘,‘CASH‘)),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement? （）A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE

4.ViewtheExhibitandexaminetheuserinformation.TheuserhasbeengrantedCONNECTandRESOURCErolesandnoindividualsystemprivileges.TheSL_REPuserexecutesthiscommandtocreateatable:SQL>CREATETABLEorders(oidnumber(6),odatedate,ccodenumber(4),oamtnumber(10,2))TABLESPACEpurchase_space;ThePURCHASE_SPACEtablespacealreadyexistsinthedatabase.Whichstatementdescribestheeffectofthecommand（）A.ThecommandexecutessuccessfullyandcreatesthetableintheUSERStablespace.B.ThecommandexecutessuccessfullyandcreatesthetableinthePURCHASE_SPACEtablespace.C.Thecommandproducesanerrorbecausetheuserdoesnothavetheprivilegetocreatethetable.D.ThecommandproducesanerrorbecausetheuserdoesnothavequotainthePURCHASE_SPACEtablespace.

参考答案和解析
参考答案：B, D
更多“Examinethecommandthatisusedtocreateatable:SQL>CREATETABLEorders(oidNUMBER(6)PRIMARYKEY, ”相关问题

  • 第1题：

    Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement? （）

    A. SER_NO

    B. ORDER_ID

    C. STATUS

    D. PROD_ID

    E. ORD_TOTAL

    F. composite index on ORDER_ID and ORDER_DATE


    参考答案：A, F

  • 第2题：

    下列对于教学视频中“学生选课”数据库的基本表定义中，正确的是（）

    A.CREATE TABLE S (SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );#B.CREATE TABLE C (CNO CHAR(6) PRIMARY KEY, CN CHAR(10) NOT NULL, PC CHAR(10), FOREIGN KEY (PC) REFERENCES C(CNO) );#C.CREATE TABLE C (CNO CHAR(6), CN CHAR(10) NOT NULL, PC CHAR(6) FOREIGN KEY, PRIMARY KEY (CNO) );#D.CREATE TABLE SC (SNO CHAR(6) PRIMARY KEY, CNO CHAR(6) PRIMA
    CREATE TABLE S ( SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );

  • 第3题：

    1、下列对于教学视频中“学生选课”数据库的基本表定义中，正确的是（）

    A.CREATE TABLE S (SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );#B.CREATE TABLE C (CNO CHAR(6) PRIMARY KEY, CN CHAR(10) NOT NULL, PC CHAR(10), FOREIGN KEY (PC) REFERENCES C(CNO) );#C.CREATE TABLE C (CNO CHAR(6), CN CHAR(10) NOT NULL, PC CHAR(6) FOREIGN KEY, PRIMARY KEY (CNO) );#D.CREATE TABLE SC (SNO CHAR(6) PRIMARY KEY, CNO CHAR(6) PRIMA
    CREATE TABLE S ( SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );

  • 第4题：

    在oracle数据库中,检查用于创建表的命令:SQL>CREATETABLE orders(oidNUMBER(6)PRIMARYKEY,odateDATE,ccodeNUMBER(6),oamtNUMBER(10,2))TABLESPACEusers;下列哪两种说法正确()。

    A.Orders表是在USERS表空间中创建的唯一对象

    B.一个NOTNULL约束的OID列上创建

    C.CHECK约束是在OID列上创建

    D.Orders表和唯一索引都在USERS表空间中创建


    参考答案：BD

  • 第5题：

    下列关于教学视频中“学生选课”数据库的基本表定义中，正确的是（）

    A.CREATE TABLE S (SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );#B.CREATE TABLE C (CNO CHAR(6) PRIMARY KEY, CN CHAR(10) NOT NULL, PC CHAR(10), FOREIGN KEY (PC) REFERENCES C(CNO) );#C.CREATE TABLE C (CNO CHAR(6), CN CHAR(10) NOT NULL, PC CHAR(6) FOREIGN KEY, PRIMARY KEY (CNO) );#D.CREATE TABLE SC (SNO CHAR(6) PRIMARY KEY, CNO CHAR(6) PRIMA
    CREATE TABLE S ( SNO CHAR(6), SN CHAR(10) NOT NULL, SEX CHAR(2) DEFAULT '男', SB DATE, SD CHAR(16), CHECK (SEX IN ('男','女')), PRIMARY KEY (SNO) );

相关内容