搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

The ORDERS table has these columns:<br /> ORDER_ID NUMBER(4) NOT NULL<br /> CUSTOMER_ID NUMBER(12) NOT NULL<br /> ORDER_TOTAL NUMBER(10,2)<br /> The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.<br /> 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:<br /> ORDER_ID NUMBER(4) NOT NULL<br /> CUSTOMER_ID NUMBER(12) NOT NULL<br /> ORDER_TOTAL NUMBER(10,2)<br /> The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.<br /> Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）”相关的问题
第1题
[多选题] Evaluate the following statements: What are the two consequences of the above statements?（）

A、Partitions of PURCHASE_ORDER_ITEMS have system-generated names.  B、Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.  C、Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.  D、The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.  E、Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.  

点击查看答案
第2题
[] View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（） View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）

A、A. The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.  B、B. The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.  C、C. The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.  D、D. The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.  

点击查看答案
第3题
[] Examine the data from the ORDERS and CUSTOMERS table. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（） Examine the data from the ORDERS and CUSTOMERS table. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

A、A.
B.
C.
D.  

点击查看答案
第4题
[多选题] 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  

点击查看答案
第5题
[] 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? （） 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、A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;  B、B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;  C、C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;  D、D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;  E、E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;  

点击查看答案
第6题
[多选题] On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

A、Only the ORD_CUSTOMER_IX1 index created.  B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.  C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.  D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.  E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.  F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.  

点击查看答案
第7题
[单选题] 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 Table  B、 Flashback Query  C、Flashback Version Query  D、 Flashback Transaction Query  

点击查看答案
第8题
[] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（） Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）

A、A.A  B、B.B  C、C.C  D、D.D  E、E.E  

点击查看答案
第9题
[多选题] The ORDERS table has these columns: 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;  

点击查看答案
第10题
[单选题] 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 );  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服