单项选择题
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.
You place the DATA1 tablespace in backup mode by issuing the following statement：
ALTER TABLESPACE data1 BEGIN BACKUP；
While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database，the database will not be opened.
相关考题
-
多项选择题
Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database -
单项选择题
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive -
单项选择题
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script： SQL> @utlrp.sql What is the significance of executing this script？（）
A. It performs parallel recompilation of only the stored PL/SQL code.
B. It performs sequential recompilation of only the stored PL/SQL code.
C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
