SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
第1题:
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? ()
第2题:
Which statement accomplish this? ()
第3题:
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? ()
第4题:
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?()
第5题:
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?()
第6题:
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? ()
第7题:
A CHECK constraint is created on the OID column.
A NOT NULL constraint is created on the OID column.
The ORDERS table is the only object created in the USERS tablespace.
The ORDERS table and a unique index are created in the USERS tablespace.
The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
第8题:
SELECT TOTAL(*) FROM customer;
SELECT COUNT(*) FROM customer;
SELECT TOTAL(customer_id) FROM customer;
SELECT COUNT(customer_id) FROM customer;
SELECT COUNT(customers) FROM customer;
SELECT TOTAL(customer_name) FROM customer;
第9题:
A CHECK constraint is created on the OID column.
A NOT NULL constraint is created on the OID column.
The ORDERS table is the only object created in the USERS tablespace.
The ORDERS table and a unique index are created in the USERS tablespace.
The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
第10题:
Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
第11题:
SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
第12题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
composite index on ORDER_ID and ORDER_DATE
第13题:
The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the order value is more than 30000, the details have to be added to the LARGEjDRDERS table. The order ID, order date, and order total should be added to the ORDERJHISTORY table, and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use? ()
第14题:
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) ()
第15题:
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?()
第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? ()
第17题:
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?()
第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? ()
第19题:
SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
第20题:
displaying the total order value for sales representatives 161 and 163
displaying the order total for sales representative 161 in the year 1999
displaying the number of orders that have order mode online and order date in 1999
displaying the number of orders whose order total is more than the average order total for all online orders
第21题:
SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;
第22题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
composite index on ORDER_ID and ORDER_DATE
第23题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
Composite index on ORDER_ID and ORDER_DATE
第24题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
Composite index on ORDER_ID and ORDER_DATE