[单选题]
1. 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
[多选题]
2.For which of the following can you use Segment Shrink? (Choose all that
apply.)
你可以使用段收缩用于以下哪些？
A、Heap tables
B、Tables with function-based indexes
C、Indexes
D、Partitions and subpartitions
E、None of the above
答案: ACD
[单选题]
3. 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 DEPENDENCIEStruncated zip file怎么解决
B、INCLUDING DEPENDENCIES CASCADE
C、COMPACT
D、CASCADE
E、None of the above
答案: D
[多选题]
4. Which of these represent the main components of Database Resource Manager? (Choose all that apply.)
哪些代表数据库资源管理器的主要组成部分？
A、Resource consumer groups
B、Resource plans
C、Resource-plan groups
D、Resource-plan directives
E、All of the above
答案: ABD
[单选题]
5.Every resource plan must contain an allocation to which consumer group?
每一个资源计划必须包含一个分配额给哪些消费组？
A、LOW_GROUP
B、SYS_GROUP
C、DEFAULT_GROUP
D、BASE_GROUP
E、OTHER_GROUPS
答案: E
6. Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group
mappings?
哪一个DBMS 资源管理器过程优先考虑消费者组映射？
A、CREATE_MAPPING_PRIORITY
B、SET_MAPPING_PRIORITY
C、SET_MAPPING_ORDER
D、PRIORITIZE_MAPPING_ORDER
E、This functionality is not available through the DBMS_RESOURCE_MANAGER package.
答案: B

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。