单选题You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：   ERROR 

题目
单选题
You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：   ERROR at Line 1：   ORA-10635： Invalid segment or tablespace type   What could be the reason？ （）
A

The table is partitioned

B

The table name is wrong.

C

It is an index-Organized table （IOT）

D

The table is stored in locally managedtablespace.

E

The table is stored in atablespacewhere segment space is managed manually.

相似考题

1.View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

2. 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.

3. In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）A、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE

4.You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

更多“单选题You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：   ERROR ”相关问题

  • 第1题：

    When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）

    • A、 INCLUDING DEPENDENCIES
    • B、 INCLUDING DEPENDENCIES CASCADE
    • C、 COMPACT
    • D、 CASCADE
    • E、 None of the above

    正确答案:D

  • 第2题：

    You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）

    • A、The table is partitioned
    • B、The table name is wrong.
    • C、It is an index-Organized table （IOT）
    • D、The table is stored in locally managedtablespace.
    • E、The table is stored in atablespacewhere segment space is managed manually.

    正确答案:E

  • 第3题：

    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

    • A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
    • B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
    • C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
    • D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

    正确答案:C

  • 第4题：

    单选题
    You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
    A

    Segment Advisor 

    B

    SQL Tuning Advisor 

    C

    SQL Access Advisor 

    D

    Segment Resource Estimation 

    E

    Automatic Database Diagnostic Monitor (ADDM)


    正确答案： A
    解析： 暂无解析

  • 第5题：

    单选题
    You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：   ERROR at Line 1：   ORA-10635： Invalid segment or tablespace type   What could be the reason？ （）
    A

    The table is partitioned

    B

    The table name is wrong.

    C

    It is an index-Organized table （IOT）

    D

    The table is stored in locally managedtablespace.

    E

    The table is stored in atablespacewhere segment space is managed manually.


    正确答案： C
    解析： 暂无解析

  • 第6题：

    单选题
    In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）
    A

     REBUILD

    B

     CASCADE

    C

     TRUNCATE

    D

     ROW MOVEMENT

    E

     SHRINK SPACE COMPACT

    F

     SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The data in the segment will be compacted but the high water mark will not be adjusted 

    B

    The EMPLOYEES table will be changed to read-only mode during the shrink operation 

    C

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

    D

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

    E

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）
    A

    The shrink operation touches every block in the BOOKING table

    B

    The high-water mark (HWM) for the BOOKING table is shifted from its original position

    C

    The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

    The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
    A

     You must enable the block change tracking feature.

    B

     You must have enable the flashback feature.

    C

     You must use the OMF in your database.

    D

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The EMPLOYEES table will be changed to read-only mode during the shrink operation.

    B

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

    C

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

    D

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）
    A

     INCLUDING DEPENDENCIES

    B

     INCLUDING DEPENDENCIES CASCADE

    C

     COMPACT

    D

     CASCADE

    E

     None of the above


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）

    • A、 The shrink operation touches every block in the BOOKING table
    • B、 The high-water mark （HWM） for the BOOKING table is shifted from its original position
    • C、 The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
    • D、 The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

    正确答案:C

  • 第14题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

    • A、 SQL Tuning Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 Segment Advisor

    正确答案:D

  • 第15题：

    You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：   ERROR at Line 1：   ORA-10635： Invalid segment or tablespace type   What could be the reason？ （）

    • A、The table is partitioned
    • B、The table name is wrong.
    • C、It is an index-Organized table （IOT）
    • D、The table is stored in locally managedtablespace.
    • E、The table is stored in atablespacewhere segment space is managed manually.

    正确答案:E

  • 第16题：

    多选题
    You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR：   ORA-12154：TNS：couldnot resolve service name   Which network configuration files would you look into to resolve this error？（）
    A

    snmp.ora

    B

    names.ora

    C

    spfile.ora

    D

    sqlnet.ora

    E

    listener.ora

    F

    tnsnames.ora


    正确答案： E,B
    解析： 暂无解析

  • 第17题：

    单选题
    You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）
    A

    The table is partitioned

    B

    The table name is wrong.

    C

    It is an index-Organized table （IOT）

    D

    The table is stored in locally managedtablespace.

    E

    The table is stored in atablespacewhere segment space is managed manually.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。
    A

    identify the segments that you should shrink

    B

    modify the storage parameters for the tablespace

    C

    automatically shrink the segments with unused space

    D

    check the alerts generated for the tablespace that is running low on space


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）
    A

     The shrink operation touches every block in the BOOKING table

    B

     The high-water mark （HWM） for the BOOKING table is shifted from its original position

    C

     The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

     The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You issued the following command：   ALTER TABLE SCOTT.EMP SHRINK SPACE；   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：   ORA-10635： Invalid segment or tablespace type    What could be the reason for the failure of the command？（）
    A

     The tablespace， DATA1， is not read-only.

    B

     The tablespace， DATA1， is not autoextensible.

    C

     The tablespace， DATA1， is not offline.

    D

     The segment space management for the tablespace， DATA1， is manual.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
    A

     You must enable the row movement on the SCOTT.EMP table.

    B

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    C

     You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

    D

     You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
    A

    add data files to the tablespace 

    B

    identify the segments that you should shrink 

    C

    modify the storage parameters for the tablespace 

    D

    automatically shrink the segments with unused space 

    E

    check the alerts generated for the tablespace that is running low on space


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）
    A

    REBUILD

    B

    CASCADE

    C

    TRUNCATE

    D

    ROW MOVEMENT

    E

    SHRINK SPACE COMPACT

    F

    SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

相关内容