A: Drop User
B: Tablespace Space Usage
C: Resumable Session Suspended
D: Recovery Area Low On Free Space
E: SYSTEM Tablespace Size Increment
举一反三
- 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
- 在表空间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;
- You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（） A: User session data B: Stack space C: Private SQL area D: Location of the runtime area for DML and DDL Statements E: Location of a part of the runtime area for SELECT statement
- While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（） A: General B: High Availability C: Space Usage D: Diagnostic Summary
- 下面哪个创建表空间的语句是正确的 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;
内容
- 0
Which two statements are true about alerts（） A: Clearing an alert sends the alert to the alert history. B: Response actions cannot be specified with server-generated alerts. C: The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view. D: Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.
- 1
创建用户时，使用参数（）设置用户默认的表空间 A: quota on tablespace B: tablespace C: temporary tablespace D: default tablespace
- 2
下面创建表空间的语句正确的是 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;
- 3
What is the term for the space that exists above a drop ceiling or below a raised floor and that isused for air return？（） A: NEMA area B: plenum area C: DAS area D: extended area E: RF special area
- 4
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.