CMS专题
单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）APut the database in hot backup mode and perform an on
题目
Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
Just back up the database datafiles without shutting down the database.
You will have to wait until you can shut down the database to perform the backup.
Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
相似问题和答案
第1题：
You install a SCSI adapter and a SCSI tape drive on your Windows 2000 Professional computer. You start the computer and Windows 2000 Professional detects and installs drivers for the new SCSI devices. Later the same day, you restart your computer. During the startup process, the computer stops loading Windows 2000 Professional. You then restart the computer and it stops again. You want to enable your Windows 2000 Professional computer to start successfully. What should you do?（）
- A、Start the computer in Safe Mode. Enable driver signing.
- B、Start the computer in Safe Mode. Use Device Manager to remove the SCSI tape device.
- C、Start the computer by using the Recovery Console. Repair the Master Boot Record by using the fixmbr command.
- D、Start the computer by using the Recovery Console. Disable the SCSI adapter device driver by using the disable command.
正确答案:D
第2题：
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
- A、 Enable flashback logging.
- B、 Start the database in the ARCHIVELOG mode.
- C、 Issue the ALTER DATABASE FLASHBACK ON； command.
- D、 Set the FAST_START_MTTR_TARGET initialization parameter.
正确答案:A
第3题：
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
- A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
- B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
- C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
- D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
正确答案:A
第4题：
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
- A、renaming the control files
- B、dropping a user in your database
- C、enabling or disabling redo log archiving
- D、dropping a tablespace in your database
- E、re-creating the control files， after you lost all the control files in your database
正确答案:C
第5题：
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
- A、adding a new user to the database
- B、dropping a user from the database
- C、dropping a table from the database
- D、dropping a data file from a tablespace
- E、adding a new tablespace to the database
正确答案:D,E
第6题：
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
第7题：
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
- A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
- B、 Just back up the database datafiles without shutting down the database.
- C、 You will have to wait until you can shut down the database to perform the backup.
- D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
- E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
正确答案:C
第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题：
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）
- A、 True
- B、 False
正确答案:B