违法和不良信息举报 联系客服
免费注册 登录

While Monitoring the space usage in your database that is in

题目
多选题
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?（）
A

An entry is created in the alert log file and the database instance continues to function normally

B

The log switch hangs occur for transactions until free space is available in the flash recovery area

C

The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle

D

The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）

  • A、 The new setting would be applied but no alerts would be raised immediately.
  • B、 The new setting would be applied and an alert would be raised immediately.
  • C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
  • D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.

正确答案:A

第2题：

You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）

  • A、the alert.log file
  • B、the DBA_ALERTS view
  • C、the Database Control Home page
  • D、the Database Control performance page
  • E、the Database Control Maintenance page

正确答案:C

第3题：

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?()

A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C. BACKUP DATABASE while connected to the PDB1 container

D. BACKUP DATABASE while connected to the boot container

E. BACKUP PLUGGABLE database PDB1 while connected to PDB2


参考答案：A, C

第4题：

单选题
You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）
A

the alert.log file

B

the DBA_ALERTS view

C

the Database Control Home page

D

the Database Control performance page

E

the Database Control Maintenance page


正确答案： B
解析： 暂无解析

第5题：

单选题
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


正确答案： C
解析： 暂无解析

第6题：

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

  • A、Coalesce the application tables at a regular interval.
  • B、Export and Import the application tables a regular interval.
  • C、Drop and recreate the application tables at a regular interval.
  • D、Move the application tables to a tablespace with less space usage.
  • E、Distribute the application tables across multiple tablespaces depending on usage.
  • F、Move the application tables to automatic segment space management tablespace.

正确答案:F

第7题：

You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）

  • A、 No warning level or critical level alert will be generated.
  • B、 A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.
  • C、 A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.
  • D、 A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.

正确答案:D

第8题：

While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

  • A、 It would result in an error because the warning threshold cannot be more than the critical threshold.
  • B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
  • C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
  • D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

正确答案:A

第9题：

单选题
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
A

It returns space usage of only BasicFile LOB chunks.

B

It returns space usage of only SecureFile LOB chunks.

C

It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

D

It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.


正确答案： B
解析： 暂无解析

第10题：

多选题
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）
A

BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B

BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C

BACKUP DATABASE while connected to the PDB1 container

D

BACKUP DATABASE while connected to the boot container

E

BACKUP PLUGGABLE database PDB1 while connected to PDB2


正确答案： A,D
解析： 暂无解析

更多相关问题
相关内容