CMS专题
单选题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 performi
题目
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database, the database will not be opened.
相似问题和答案
第1题：
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
- A、The database is in mount state.
- B、One of the tablespaces is offline.
- C、One of the tablespaces is read only.
- D、The database operates in ARCHIEVELOG mode.
- E、The database operates in NOARCHIEVELOG mode.
正确答案:E
第2题：
In order to perform Flashback Transaction Query operations， which of these steps are required？（）
- A、 Ensure that database is running with version 10.1 compatibility.
- B、 Enable Flashback Logging.
- C、 Enable Supplemental Logging.
- D、 Ensure that the database is running with version 10.0 compatibility.
- E、 Ensure that the database is in ARCHIVELOG mode.
正确答案:C,D
第3题：
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第4题：
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
- A、Until last commit
- B、Until the time you perform recovery
- C、Until the time the date file got corrupted
- D、Until the point where the last transaction begun
- E、You cannot recover the SYSTEMtablespaceand must re-create the database.
正确答案:A
第5题：
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D
第6题：
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）
- A、Until last commit
- B、Until the time you perform recovery
- C、Until the time the date file got corrupted
- D、Until the point where the last transaction begun
- E、You cannot recover the SYSTEMtablespaceand must re-create the database.
正确答案:A
第7题：
Which two statements are true regarding the database in ARCHIVELOG mode？（）
- A、You have to shut down the database to perform the backups.
- B、Archiving information is written to the data files and redo log files.
- C、You can perform complete database backups without closing the database.
- D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
- E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
正确答案:C,E
第8题：
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）
- A、You performed rollback after commit.
- B、If a log switch occurs in your database.
- C、Thearchiverfails to generate an archived log file.
- D、Instance recovery fails to find one of the redo log files.
- E、A long-running query is unable to get read-consistent image.
- F、If you perform manual undo management operations in auto mode.
正确答案:E
第9题：
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
- A、You can perform online whole database backups.
- B、You can performofflinewhole database backups.
- C、You cannot perform schema-level export/import operations.
- D、You can perform the backup of only the SYSTEM tablespace when the database is open.
正确答案:B
第10题：
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D