CMS专题
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00
题目
by using the Flashback Table feature
by using the Flashback Database feature
by performing incomplete recovery using RMAN utility
by performing incomplete recovery using user-managed recovery
相似问题和答案
第1题：
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
第2题：
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
第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题：
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）
- A、 UNTIL SEQUENCE
- B、 UNTIL SCN
- C、 UNTIL CHANGE
- D、 UNTIL CANCEL
正确答案:C,D
第5题：
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
第6题：
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
- A、 by using the RMAN utility
- B、 by using the export/import utility
- C、 by using the ALTER DATABASE command
- D、 by enabling the change tracking feature
正确答案:C
第7题：
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
第8题：
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
第9题：
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）
- A、 ALTER DATABASE DROP LOGFILE GROUP 1
- B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
- C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
- D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
正确答案:C
第10题：
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
- A、 backup database all
- B、 backup compressed database
- C、 backup as compressed backupset database
- D、 backup as compressed backup database plus archivelog all
- E、 backup as compressed backupset database plus compress archivelog all
正确答案:C