网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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?（）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.
考题
单选题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?（）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 overD
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
考题
单选题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?（）A
Data, Frame, Packet, Segment, BitB
Data, Frame, Segment, Packet, BitC
Data, Packet, Frame, Segment, BitD
Data, Packet, Segment, Frame, BitE
Data, Segment, Frame, Packet, BitF
Data, Segment, Packet, Frame, Bit
热门标签
最新试卷