Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE

Posted on 29/10/2024 by Tran Anh

Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command:

SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created FROM dba_objects);

U1 complains that the command is taking too long to execute.

In the alert log, the database administrator (DBA) finds this:

2017/3/6 14:45:17 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

(A). Add a data file to DATA
(B). Drop other U1 objects in DATA
(C). Increase U1’s quota sufficiently in DATA
(D). Set DEFERRED_SEGMENT_CREATION to TRUE
(E). Grant UNLIMITED TABLESPACE to U1
(F). Set AUTOEXTEND ON for data files in DATA

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