The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday, you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command: SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS; SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m; After that, you issued the following command to recreate the index: CREATE UNIQUE INDEX sales_index_pk ON sales (order_id) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE ( INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ) NOLOGGING PARALLEL( degree 4) Which two clauses are responsible for reducing the time for the recreation of the index?()
第1题:
下列语句错误的是( )
A.select * from orders where ordername is not null;
B.select * from orders where ordername<>null;
C.select * from orders where ordername is null;
D.select * from orders where ordername not is null;
第2题:
第3题:
A、may
B、can
C、will
D、ought to
第4题:
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.
B.
C.
D.
第5题:
A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE
B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE
C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
第6题:
第7题:
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;
第8题:
下面检索结果一定不是一行的命令是( )
A.select distinct * from orders ;
B.select * from orders limit 1,2;
C.select top 1 * from orders;
D.select * from orders limit 1;
第9题:
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement?()
CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG
MAXLOGFILES20
MAXLOGMEMBERS3
MAXDATAFILES30
MAXINSTANCES10
MAXLOGHISTORY1200
LOGFILE
GROUP1(
’/disk1/prod/orders/db/log1a.dbf’,
’/disk2/prod/orders/db/log1b.dbf’
)SIZE100K
GROUP2(
’/disk1/prod/orders/db/log2a.dbf’,
’/disk2/prod/orders/db/log2b.dbf’
)SIZE100K,
DATAFILE
’/disk1/prod/orders/db/database1.dbf’,
’/disk2/prod/orders/db/file1.dbf’;
第10题:
How many orders are included in standard ship orders? Can you list some?