可学答题网 > 问答 > 1z0-043题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The ORDERS table in&en


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
参考答案
参考解析:
分类:1z0-043题库
相关推荐

1、若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值

若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值为()A0B-1C1D2

2、AMPS属于()。

AMPS属于()。A1GB2GC3GD4G

3、cAMP(cyclic AMP)

cAMP(cyclic AMP)

4、表达式10>5&&6%3的值是()

表达式10>5&&6%3的值是()A-1B非零值C0D1

5、The TRANS_SUMMARY table&ens

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction...

6、What would the amps be at 240 volts wi

What would the amps be at 240 volts with an 8 ohm resistance?()A32~5 ampsB25 ampsC1~5 ampsD30 am