A. Enable the flash recovery area and specify it as the……

多项选择题Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE mydir rman_change_track.f; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?（）

A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

单项选择题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

A. The database will open, and the tablespace automatically comes out of the backup mode.
B. The database will be mounted, and recovery must be performed on the USERS tablespace.
C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

多项选择题Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）

A. Stored scripts in the recovery catalog
B. Backups that can be deleted from disk
C. Backup sets and images copies that are obsolete
D. Backups that do not have the AVAILABLE status in the RMAN repository

单项选择题Examine the following commands and their output: SQL> SELECT ename, sal FROM emp WHERE ename=JAMES; ENAME SAL JAMES 1050 QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=JAMES; 1 row updated. SQL> SELECT ename, sal FROM emp WHERE ename=JAMES; ENAME SAL JAMES 2310 View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.

多项选择题You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup