多项选择题

Examine the statement：
SQL> CREATE TABLESPACE user_data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO；
Which twp assumptions must be true for this statement to execute successfully？（）

A.Oracle Managed Files are used for this instance.
B.The USER_DATA tablespace is managed using FET$/UET$ tables.
C.The COMPATIBLE initialization parameter must be 9.0.0 or higher.
D.Space within segments in the USER_DATA tablespace is managed with freelists.

点击查看答案

上一题目录下一题

相关考题

单项选择题

The EMPLOYEES table is stored in the SAMPLE tablespace.
The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.
Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.
Which object will be exported by this command？（）
exp system/manager tablespaces=SAMPLE

A.Only the EMPLOYEES table.
B.Only the EMPLOYEES table and its corresponding primary key index.
C.The EMPLOYEES table and partition P1.
D.The EMPLOYEES table， IPK_EMP index， and the SALES table.

单项选择题

What should you look at first to compute the number of undo blocks written per second to disk？（）

A.V$UNDOSTAT
B.V$TRANSACTION
C.V$ROLLSTAT
D.DBA_UNDO_EXTENTS
E.DBA_ROLLBACK_SEGS

单项选择题

What is true regarding a transaction executed in Automatic Undo Management mode？（）

A.A
B.B
C.C
D.D

Examine the statement： SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）

相关考题

Examine the statement：
SQL> CREATE TABLESPACE user_data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO；
Which twp assumptions must be true for this statement to execute successfully？（）