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: 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;