Q75 In your data center, Oracle Managed Files (OMF) is used for all databases

Posted on 29/10/2024 by Tran Anh

Q75 In your data center, Oracle Managed Files (OMF) is used for all databases.

All tablespaces are smallfile tablespaces.

SALES_Q1 is a permanent user-defined tablespace in the SALES database.

Examine this command which is about to be issued by a DBA logged in to the SALES database:

ALTER TABLESPACE sales_q1 ADD DATAFILE;

Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

(A). Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
(B). Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
(C). Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
(D). Add the AUTOEXTEND ON clause with NEXT set to 100M.
(E). Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận