单选题

View the Exhibit and examine the undo tablespace attributes.    Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces.  What happens to the new DML operations in this scenario()

AThe DML commands will fail.

BThe undo data generated by the DML is stored in one of the two other undo tablespaces.

CThe undo data generated by the DML will overwrite the extents that contain committed undo data. 

DThe undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM

正确答案

来源:www.examk.com

答案解析

相似试题
  • View the Exhibit. Which statements are true regarding the USERS tablespace()

    多选题查看答案

  • View the Exhibit and identify the component marked with a question mark. ()

    单选题查看答案

  • View the Exhibit and identify the component marked with a question mark.()

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident()

    单选题查看答案