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

You created the DEPT&e


You created the DEPT table by using the following command:   CREATE TABLE scott.dept   (deptno NUMBER(3),   dname VARCHAR2(15),   loc VARCHAR2(15) )   STORAGE (INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()

  • A Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
  • B Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
  • C Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
  • D You cannot shrink the SCOTT.EMP table.
参考答案
参考解析:
分类:1z0-043题库
相关推荐

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

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

2、You create a virtual&e

You create a virtual machine (VM) named Server1. You export the VM to the C:VM folder.&...

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

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

4、You create an Oracle&e

You create an Oracle 10g database and configure the SPFILE as follows:  SGA_TARGET=2G  DB...

5、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

6、“频段0”的CDMA2000-1X系统沿用了AMPS的信道编号,一个AMPS

“频段0”的CDMA2000-1X系统沿用了AMPS的信道编号,一个AMPS的信道编号对应的频谱宽度是多少?()A200KHzB30KHzC25KHzD150KHz