网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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;
参考答案
参考解析
解析：
暂无解析
更多 “多选题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? （）ASELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;BSELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;CSELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;DSELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and = 2000;ESELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and order_total = 2000;” 相关考题
考题
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.
考题
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;
考题
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
考题
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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. composite index on ORDER_ID and ORDER_DATE
考题
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()
A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
考题
Make a function to print an HTML table of r rows and c cols; fill the cells with up to n consecutivenumbers (if n is greater than the produce of r and c, discard the rest). Ensure that all rows have thesame number of columns.
考题
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.
考题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
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.
考题
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_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、composite index on ORDER_ID and ORDER_DATE
考题
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDERS table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDERS table are disabled.D、The dependent referential integrity constraints in the ORDERS table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）A
The statement would not execute because table aliases are not allowed in the JOIN clause.B
The statement would not execute because the table alias prefix is not used in the USING clause.C
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
考题
单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）A
Flashback TableB
Flashback QueryC
Flashback Version QueryD
Flashback Transaction Query
考题
单选题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);
考题
单选题The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）A
Column definitions cannot be altered to add DEFAULT values.B
A change to the DEFAULT value affects only subsequent insertions to the table.C
Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D
All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
考题
多选题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（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
多选题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） （）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
考题
多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
考题
多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE
考题
多选题Evaluate the following statements： CREATE TABLE purchase_orders （po_id NUMBER（4）， po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2）， CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date） （PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN （TO_DATE（？1-jul-2007？d-mon-yyyy？）， PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））； CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）； What are the two consequences of the above statements？（）APartitions of PURCHASE_ORDER_ITEMS have system-generated names.BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
考题
多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE
考题
单选题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 );
考题
单选题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);
考题
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
热门标签
最新试卷
