44 You want to enable resumable space allocation at the instance level. Which two actions would enab

最新推荐文章于 2023-02-14 23:06:14 发布

原创最新推荐文章于 2023-02-14 23:06:14 发布 · 944 阅读

0 ·

CC 4.0 BY-SA版权

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

本文详细介绍了如何在SQL实例级别启用可恢复空间分配，包括修改初始化参数RESUMABLE_TIMEOUT，以及动态设置该参数的方法。同时解释了为何不能通过ALTER SYSTEM ENABLE RESUMABLE;或ALTER SESSION ENABLE RESUMABLE;来实现此功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

44
You want to enable resumable space allocation at the instance level.
Which two actions would enable resumable space allocation at the instance level? (Choose two.)
A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
Explanation:
You can enable resumable space allocation at the instance level by modifying the
RESUMABLE_TIMEOUT initialization parameter to a nonzero value, or you can change the value of the
RESUMABLE_TIMEOUT parameter dynamically by issuing the following statement:
ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero_value>;
Issuing the ALTER SYSTEM ENABLE RESUMABLE; statement is incorrect. This statement would
generate an error on execution because the syntax is incorrect.
Issuing the ALTER SESSION ENABLE RESUMABLE; statement is incorrect. You issue the ALTER
SESSION ENABLE RESUMABLE; statement to enable resumable space allocation at the session level,
not to enable resumable space allocation at the instance level.