单选题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 operationC Deallocates space above the high-water mark that is currently not in useD None of the above
单选题
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
参考解析
解析：
暂无解析
相关考题：
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
Which of the following shows the proper pronunciation of the segment "did you" inconnected speech?
In an iostat report， which of the following options best describes the value of % tm_act？（）A、 The total CPU usage for this driveB、 The bandwidth utilization of the indicated driveC、 It can best be represented by the equation （%iowait - %ioidle）D、 It can best be represented by the equation （kilobytes read/kilobytes written） *100
Which of the following BEST describes RAID 1?（）A、MirroringB、StripingC、Striping with parityD、Striping with mirroring
Which of the following describes an area where communications equipment is stored?（）A、HVACB、MDFC、110 blockD、Demarc
In an iostat report， which of the following options best describes the value of % idle？（）A、 A representation of the equation （tps/kbps）*100B、 The percentage of time the disks are idle with no activityC、 The percentage of time the disks are idle with no outstanding CPU requestsD、 The percentage of time the CPU is idle with no outstanding disk I/O requests
Selling the total solution includes adding services and financing options which ensures your customer will remain satisfied with their purchase. Which of the following best describes the benefits of Selling options， storage， services， and financing to your clients？（）A、More face time with the executivesB、Enhanced credibility， higher profits， less competitive pressureC、One source for elements， cleaner design， simpler supportD、Locks competitors out of account
In order to increase reliability， minimize collisions and establish a large number of systems on an Ethernet segment， which of the following options should be selected for the Ethernet network？（）A、10BaseTB、Switched 10BaseTC、Switched 100BaseT Half-DuplexD、Switched 100BaseT Full-Duplex
Companycom would like the ability to shrink filesystems. They currently have JFS filesystems. Which of the following is necessary to shrink the filesystems?（）A、Copy the existing filesystems to JFS2B、Defragment the filesystem， then reduce its sizeC、Change the file system attribute allow_shrink=yes on the existing filesystemsD、Modify the logical volume attribute allow_shrink=yes on the existing logical volumes
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 DEPENDENCIESB、 INCLUDING DEPENDENCIES CASCADEC、 COMPACTD、 CASCADEE、 None of the above
For which of the following can you use Segment Shrink？（）A、 Heap tablesB、 Tables with function-based indexesC、 IndexesD、 Partitions and subpartitionsE、 None of the above
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
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 operationC、 Deallocates space above the high-water mark that is currently not in useD、 None of the above
单选题In an iostat report， which of the following options best describes the value of % iowait？（）A The amount of time taken to service an I/O interruptB The percentage of time CPU（s） are waiting for page insC The percentage of time the CPU9（s） are waiting on networkD The percentage of time the CPU（s） are waiting for outstanding disk I/O requests
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
单选题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 DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above
多选题Which of the following devices can an administrator use to segment their LAN?（）AHubsBRepeatersCSwitchesDBridgesERoutersFMedia ConvertersGAll of the above
单选题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
单选题In an iostat report， which of the following options best describes the value of % idle？（）A A representation of the equation （tps/kbps）*100B The percentage of time the disks are idle with no activityC The percentage of time the disks are idle with no outstanding CPU requestsD The percentage of time the CPU is idle with no outstanding disk I/O requests
单选题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?（）AThe EMPLOYEES table will be changed to read-only mode during the shrink operation.BThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.CThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.DData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
单选题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.
单选题In an iostat report， which of the following options best describes the value of % tm_act？（）A The total CPU usage for this driveB The bandwidth utilization of the indicated driveC It can best be represented by the equation （%iowait - %ioidle）D It can best be represented by the equation （kilobytes read/kilobytes written） *100
多选题For which of the following can you use Segment Shrink？（）AHeap tablesBTables with function-based indexesCIndexesDPartitions and subpartitionsENone of the above
单选题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?（）AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
单选题A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?（）AData, Frame, Packet, Segment, BitBData, Frame, Segment, Packet, BitCData, Packet, Frame, Segment, BitDData, Packet, Segment, Frame, BitEData, Segment, Frame, Packet, BitFData, Segment, Packet, Frame, Bit