在表空间space中没有存储任何数据,现在需要删除该表空间,并同时删除其对应的数据文件,可以使用下列哪条语句?______
A: DROP TABLESPACE space;
B: DROP TABLESPACE space INCLUDING DATAFILES;
C: DROP TABLESPACE space NCLUDING CONTENTS AND DATAFILES;
D: DROP TABLESPACE space AND DATAFILES;
A: DROP TABLESPACE space;
B: DROP TABLESPACE space INCLUDING DATAFILES;
C: DROP TABLESPACE space NCLUDING CONTENTS AND DATAFILES;
D: DROP TABLESPACE space AND DATAFILES;
举一反三
- 下列关于DROP TABLESPACE用法错误的是() A: drop tablesapce tbs1 B: drop tablesapce tbs1 including datafiles C: drop tablesapce tbs1 including contents D: drop tablesapce tbs1 including contents and datafiles
- 在表空间space中没有存储任何数据，现在需要删除该表空间，并同时删除其对应的数据文件，可以使用下列哪条语句？
- Identify the three predefined server-generated alerts. （） A: Drop User B: Tablespace Space Usage C: Resumable Session Suspended D: Recovery Area Low On Free Space E: SYSTEM Tablespace Size Increment
- 创建用户时，使用参数（）设置用户默认的表空间 A: quota on tablespace B: tablespace C: temporary tablespace D: default tablespace
- Identify the three predefined server-generated alerts.（） A: ADrop User B: BTablespace Space Usage C: CResumable Session Suspended D: DRecovery Area Low On Free Space E: ESYSTEM Tablespace Size Increment