单选题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 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A by using the Flashback Table featureB by using the Flashback Database featureC by performing incomplete recovery using RMAN utilityD by performing incomplete recovery using user-managed recovery
单选题
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 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）
A
by using the Flashback Table feature
B
by using the Flashback Database feature
C
by performing incomplete recovery using RMAN utility
D
by performing incomplete recovery using user-managed recovery
参考解析
解析：
暂无解析
相关考题：
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 containerB. 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$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
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.
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 commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
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 utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
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.
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 commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
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.
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 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
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 SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
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 allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题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 1B ALTER DATABASE CLEAR LOGFILE GROUP 1C ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
单选题For which database operation would you need the database to be in the MOUNT state（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.
多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
多选题Which two statements are true regarding the database in ARCHIVELOG mode？（）AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
单选题You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should you take to enable archiving at instance startup？（）A AB BC CD D
单选题You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）AEnable the flash recovery area and specify it as the archived redo log destination.BDisable the flash recovery area and start the database instance in ARCHIVELOG mode.CEnable the flash recovery area but do not specify it as the archived redo log destination.DDisable the flash recovery area and start the database instance in NOARCHIVELOG mode.
单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）Abackup database plus archivelogBbackup database plus archivlog until time ‘10:00‘Cbackup database plus archivelog timeout ‘10:00‘Dbackup database plus archivelog duration 10:00
单选题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？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
单选题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 utilityB by using the export/import utilityC by using the ALTER DATABASE commandD by enabling the change tracking feature
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）AThe database is in mount state.BOne of the tablespaces is offline.COne of the tablespaces is read only.DThe database operates in ARCHIEVELOG mode. EThe database operates in NOARCHIEVELOG mode.
单选题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？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
多选题You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
单选题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?（）AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging