When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（） A:  The SYSTEM tablespace. B:  The UNDO tablespace. C:  All tablespaces with tables. D:  All tablespaces with indexes. E:  No tablespaces are automatically restored.

When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（） A: A The SYSTEM tablespace. B: B The UNDO tablespace. C: C All tablespaces with tables. D: D All tablespaces with indexes. E: E No tablespaces are automatically restored.

创建用户时，使用参数（）设置用户默认的表空间 A: quota on tablespace B: tablespace C: temporary tablespace D: default tablespace

仅仅备份表空间使用（ ）命令完成。 A: BACKUP TABLESPACE B: BACKUP DATABASE C: BACKUP TABLE D: RESTORE TABLESPACE

下面哪个创建表空间的语句是正确的 A: CREATE TABLESPACE TBS DATAFILE 'tbs1.dbf' SIZE 50M; B: CREATE TABLESPACE TBS DATAFILE 'tbs1.dbf' SIZE 50M,'tbs2.dbf' SIZE 100M; C: CREATE UNDO TABLESPACE TBS DATAFILE 'tbs1.dbf' SIZE 50M; D: CREATE TEMPORARY TABLESPACE TBS TEMPFILE 'tbs1.dbf' SIZE 50M;

在表空间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;

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: CREATE TABLESPACE XXX TEMPFILE 'C:\XXX.DBF'SIZE 50m; B: CREATE UNDO TABLESPACE XXX TEMPFILE 'C:\XXX.DBF'SIZE 50m; C: CREATE TEMPORARY TABLESPACE XXX TEMPFILE 'C:\XXX.DBF'SIZE 50m; D: CREATE TEMPORARY TABLESPACT XXX DATAFILE 'C:\XXX.DBF'SIZE 50m;

Sorts can be managed efficiently by assigning ( ) tablespace to sort operations. A: SYSTEM B: TEMPORARY C: ROLLBACK D: USERS

When the database is open, which of the following tablespace must be online?() A: SYSTEM B: TEMPORARY C: ROLLBACK D: USERS