试题详情
- 多项选择题 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?()
A、 PCTFREE
B、 MAXTRANS
C、 PCTINCREASE
D、 INITIAL
E、 NOLOGGING
F、 PARALLEL
- E,F
关注下方微信公众号,在线模考后查看
热门试题
- The database
- What elements of glo
- You work
- 在SQL*PLUS中显示EMP表结构的命
- Evaluate this SQL s
- What are
- Which three statemen
- Given: What is
- You issue&ensp
- 下列哪个不是有效的数据库状态?()
- 以下关于PL/SQL块的说法正确的是()
- Which three
- Which interfac
- Which statements are
- You would like to di
- While setting&
- Your database&
- Given: Which c
- Your database&
- Your database&