1z0-043单项选择题每日一练(2019.01.24)

单项选择题
The loss of the control file forced you to re-create the control file. After re-creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five-digit number starting with 0. What could be the possible reason？（）
A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered.
单项选择题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）
A. Zero
B. One or more
C. NONE
D. DEFAULT
单项选择题
You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）
A. The tablespace， DATA1， is not read-only.
B. The tablespace， DATA1， is not autoextensible.
C. The tablespace， DATA1， is not offline.
D. The segment space management for the tablespace， DATA1， is manual.
单项选择题
You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）
A. Flashback logs are not deleted.
B. Flashback logs are deleted automatically.
C. Flashback logs are deleted only if you are using Recovery Manager （RMAN）
D. Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
E. Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
单项选择题
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE; What would you see in the output？（）
A.a list of all the expired backups and copies
B.a list of all those files that have been deleted in the last two days
C.a list of all those files that have been recovered within the last two days
D.a list of backups and copies that are outside the range covered by the current retention policy