CUUG OCP 19c 认证1Z0-082考试题库（第1题）

CUUG OCP 19c 认证1Z0-082考试题库（第1题）-CUUG内部学员版082题库解析

1. You execute this command:

CREATE BIGFILE TABLESPACE big_tbs

DATAFILE '/u01/oracle/data/big_f1.dbf'

SIZE 20G;

Sufficient storage is available in filesystem /u01.

Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A. AUTOEXTEND is possible for the datafile

B. It must be bigger than the largest SMALLFILE tablespace

C. Additional data files may not be added

D. It will be a dictionary-managed tablespace by default

E. It will always have a 32K block size

Answer: AC

(解析：bigfile 表空间只允许一个数据文件，一般都是自动扩展)