ITPub博客

首页 > 数据库 > Oracle > ocp 19c考题,科目082考试题(15)-move datafile to

ocp 19c考题,科目082考试题(15)-move datafile to

Oracle 作者:unix_5030 时间:2022-01-17 11:37:09 0 删除 编辑

15.Examine this command:

ALTER DATABASE

MOVE DATAFILE '/u01/sales1.dbf'

TO /u01/sales01.dbf'

REUSE;

Which two statements are true? (Choose two.)

A. DML may be performed on tables with one or more extents in this data file during the execution of this command.

B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

E. The file is renamed and stored in the same location

source : cuug


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70010796/viewspace-2852578/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2021-11-30

  • 博文量
    36
  • 访问量
    15887