单选题Which of the following options describes Segment Shrink？（）AReclaims space above and below the high-water mark without using additional spaceBMoves rows to a new physical location，resetting the high-water mark，but uses additional space during the operat

题目
单选题
Which of the following options describes Segment Shrink？（）
A

 Reclaims space above and below the high-water mark without using additional space

B

 Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation

C

 Deallocates space above the high-water mark that is currently not in use

D

 None of the above

相似考题

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.A technician needs to install additional access points for a new high speed connection being added in the new office space. Which of the following will MOST likely be installed to allow additional CAT5 cable connections?（）A. Smart JackB. DemarcC. 110 BlockD. 66 Block

3.Which of the following is an advantage of using a KVM with multiple servers？（）A、Eliminates the need for backup tapesB、Increases redundancyC、Saves physical space in the racksD、Offers additional runtime for the UPS

4.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 tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positionC. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

更多“单选题Which of the following options describes Segment Shrink？（）A  Reclaims space above and below the high-water mark without using additional spaceB  Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the op”相关问题

  • 第1题：

    Which of the following BEST describes a Blade server？（）

    • A、Provides higher levels of physical redundancy than a typical server
    • B、Provides better rack space utilization than a typical server
    • C、Is 1.75 inches in height to fit properly in a rack
    • D、Uses an unshared backplane

    正确答案:B

  • 第2题：

    A technician needs to install additional access points for a new high speed connection being added in the new office space. Which of the following will MOST likely be installed to allow additional CAT5 cable connections?（）

    • A、Smart Jack
    • B、Demarc
    • C、110 Block
    • D、66 Block

    正确答案:C

  • 第3题：

    Which command will increase the contiguous free space of a file system without having to add additional partitions？（）

    • A、chfs
    • B、fsck
    • C、chlv
    • D、defragfs

    正确答案:D

  • 第4题：

    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

  • 第5题：

    Which of the following options describes Segment Shrink？（）  

    • A、 Reclaims space above and below the high-water mark without using additional space
    • B、 Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation
    • C、 Deallocates space above the high-water mark that is currently not in use
    • D、 None of the above

    正确答案:A

  • 第6题：

    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

    • A、 space allocated in the tablespace
    • B、 space required for the bitmap index on a column of the table
    • C、 space remaining in the tablespace after creating the table
    • D、 estimated value of the PCTFREE storage parameter

    正确答案:A

  • 第7题：

    单选题
    The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode. What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）
    A

    Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially

    B

    Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command

    C

    Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command

    D

    Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command


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

  • 第8题：

    单选题
    A technician needs to install additional access points for a new high speed connection being added in the new office space. Which of the following will MOST likely be installed to allow additional CAT5 cable connections?（）
    A

    Smart Jack

    B

    Demarc

    C

    110 Block

    D

    66 Block


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    Which of the following options describes Segment Shrink？（）
    A

     Reclaims space above and below the high-water mark without using additional space

    B

     Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation

    C

     Deallocates space above the high-water mark that is currently not in use

    D

     None of the above


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

  • 第11题：

    单选题
    Which of the following is an advantage of using a KVM with multiple servers？（）
    A

    Eliminates the need for backup tapes

    B

    Increases redundancy

    C

    Saves physical space in the racks

    D

    Offers additional runtime for the UPS


    正确答案： 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题：

    A user is complaining that they ran out of paging space.  Which of the following will address this and  provide best performance（）

    • A、Expand the default paging space to the largest possible size
    • B、Create a new larger paging space
    • C、Create additional paging spaces of equal size on different disks
    • D、Reboot system

    正确答案:C

  • 第14题：

    Which  of  the  following  commands  will  ncrease  the  contiguous  free  space  of  a  file  system  without  having to add additional partitions（）

    • A、chfs
    • B、fsck
    • C、chlv
    • D、defragfs

    正确答案:D

  • 第15题：

    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

  • 第16题：

    Which three descriptions are correct about the effects of the TRUNCATE command on a table（）

    • A、The corresponding indexes for the table are also truncated.
    • B、Delete triggers on the table are fired during the execution of the TRUNCATE command.
    • C、The child table is truncated when the TRUNCATE command is applied on the parent table.
    • D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.
    • E、No undo or very little undo data is generated during the execution of the TRUNCATE command

    正确答案:A,D,E

  • 第17题：

    The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode. What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）

    • A、Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
    • B、Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command
    • C、Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command
    • D、Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command

    正确答案:B

  • 第18题：

    单选题
    Which command will increase the contiguous free space of a file system without having to add additional partitions？（）
    A

    chfs

    B

    fsck

    C

    chlv

    D

    defragfs


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

  • 第19题：

    单选题
    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）
    A

     space allocated in the tablespace

    B

     space required for the bitmap index on a column of the table

    C

     space remaining in the tablespace after creating the table

    D

     estimated value of the PCTFREE storage parameter


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

  • 第20题：

    单选题
    A user is complaining that they ran out of paging space.  Which of the following will address this and  provide best performance（）
    A

    Expand the default paging space to the largest possible size

    B

    Create a new larger paging space

    C

    Create additional paging spaces of equal size on different disks

    D

    Reboot system


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    Intact buoyancy is a term used to describe（）.
    A

    the volume of all intact spaces above the waterline

    B

    an intact space below the surface of a flooded area

    C

    an intact space which can be flooded without causing a ship to sink

    D

    the space at which all the vertical upward forces of buoyancy are considered to be concentrated


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

  • 第24题：

    单选题
    Which  of  the  following  commands  will  ncrease  the  contiguous  free  space  of  a  file  system  without  having to add additional partitions（）
    A

    chfs

    B

    fsck

    C

    chlv

    D

    defragfs


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

相关内容