单选题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 VARCHAR

题目
单选题
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);

相似考题

1.Which is a valid CREATE TABLE statement? ()A. CREATE TABLE EMP9$# AS (empid number(2));B. CREATE TABLE EMP*123 AS (empid number(2));C. CREATE TABLE PACKAGE AS (packid number(2));D. CREATE TABLE 1EMP_TEST AS (empid number(2));

2.Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? ()A. CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);B. CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));C. CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));D. CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

3. Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

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;

更多“单选题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 VARCHAR”相关问题

  • 第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题：

    Which is a valid CREATE TABLE statement? （）

    • A、CREATE TABLE EMP9$# AS (empid number(2));
    • B、CREATE TABLE EMP*123 AS (empid number(2));
    • C、CREATE TABLE PACKAGE AS (packid number(2));
    • D、CREATE TABLE 1EMP_TEST AS (empid number(2));

    正确答案:A

  • 第3题：

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

    正确答案:B

  • 第4题：

    Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(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 aboveSQL 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

  • 第5题：

    Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

    • A、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
    • B、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
    • C、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
    • D、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

    正确答案:B

  • 第6题：

    You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. 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);

    正确答案:B

  • 第7题：

    单选题
    Which is a valid CREATE TABLE statement?（）
    A

    CREATE TABLE EMP9$# AS (empid number(2));

    B

    CREATE TABLE EMP*123 AS (empid number(2));

    C

    CREATE TABLE PACKAGE AS (packid number(2));

    D

    CREATE TABLE 1EMP_TEST AS (empid number(2));


    正确答案： B
    解析： 暂无解析

  • 第8题：

    多选题
    The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_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;


    正确答案： E,D
    解析： 暂无解析

  • 第9题：

    多选题
    Examine the command that is used to create a table：  SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；  Which two statements are true about the effect of the above command） （）
    A

    A CHECK constraint is created on the OID column.

    B

    A NOT NULL constraint is created on the OID column.

    C

    The ORDERS table is the only object created in the USERS tablespace.

    D

    The ORDERS table and a unique index are created in the USERS tablespace.

    E

    The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.


    正确答案： E,D
    解析： 暂无解析

  • 第10题：

    单选题
    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);


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    多选题
    Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(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 aboveSQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

  • 第13题：

    The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）

    • A、SELECT TOTAL(*) FROM customer;
    • B、SELECT COUNT(*) FROM customer;
    • C、SELECT TOTAL(customer_id) FROM customer;
    • D、SELECT COUNT(customer_id) FROM customer;
    • E、SELECT COUNT(customers) FROM customer;
    • F、SELECT TOTAL(customer_name) FROM customer;

    正确答案:B,D

  • 第14题：

    Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

    • A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
    • B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
    • C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
    • D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

    正确答案:B

  • 第15题：

    Examine the command that is used to create a table：  SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；  Which two statements are true about the effect of the above command） （）

    • A、A CHECK constraint is created on the OID column.
    • B、A NOT NULL constraint is created on the OID column.
    • C、The ORDERS table is the only object created in the USERS tablespace.
    • D、The ORDERS table and a unique index are created in the USERS tablespace.
    • E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

    正确答案:B,D

  • 第16题：

    The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_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;

    正确答案:C,E

  • 第17题：

    You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）

    • A、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
    • B、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
    • C、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
    • D、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
    • E、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
    • F、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

    正确答案:E

  • 第18题：

    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

  • 第19题：

    多选题
    Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
    A

    A CHECK constraint is created on the OID column.

    B

    A NOT NULL constraint is created on the OID column.

    C

    The ORDERS table is the only object created in the USERS tablespace.

    D

    The ORDERS table and a unique index are created in the USERS tablespace.

    E

    The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.


    正确答案： B,E
    解析： 暂无解析

  • 第20题：

    多选题
    The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers?（）
    A

    SELECT TOTAL(*) FROM customer;

    B

    SELECT COUNT(*) FROM customer;

    C

    SELECT TOTAL(customer_id) FROM customer;

    D

    SELECT COUNT(customer_id) FROM customer;

    E

    SELECT COUNT(customers) FROM customer;

    F

    SELECT TOTAL(customer_name) FROM customer;


    正确答案： A,F
    解析： 暂无解析

  • 第21题：

    单选题
    You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. 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);


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）
    A

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );

    B

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );

    C

    CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );

    D

    CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );

    E

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );

    F

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );


    正确答案： E
    解析： 暂无解析

  • 第23题：

    多选题
    The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_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;


    正确答案： A,E
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： F,C
    解析： 暂无解析

相关内容