单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）A alter tablespace DAVE_TBS backup modeB alter tablespace DAVE_TBS start backup C alter tablespace DAVE_TBS begin backup D alter tablespace DAVE_TBS bac
题目
alter tablespace DAVE_TBS backup mode
alter tablespace DAVE_TBS start backup
alter tablespace DAVE_TBS begin backup
alter tablespace DAVE_TBS backup begin
alter tablespace DAVE_TBS backup
相似考题
更多“单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）A alter tablespace DAVE_TBS backup modeB alter tablespace DAVE_TBS start backup C alter tablespace DAVE_TBS begin backup D alter tablespace DAVE_TBS bac”相关问题
-
第1题：
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）
- A、 alter tablespace DAVE_TBS backup mode
- B、 alter tablespace DAVE_TBS start backup
- C、 alter tablespace DAVE_TBS begin backup
- D、 alter tablespace DAVE_TBS backup begin
- E、 alter tablespace DAVE_TBS backup
正确答案:C -
第2题：
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）
- A、alter tablespace DAVE_TBS backup mode
- B、alter tablespace DAVE_TBS start backup
- C、alter tablespace DAVE_TBS begin backup
- D、alter tablespace DAVE_TBS backup begin
- E、alter tablespace DAVE_TBS backup
正确答案:C -
第3题：
Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）
- A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
- B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
- C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
- D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
正确答案:C -
第4题：
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
- A、 alter tablespace MY_DATA begin backup
- B、 alter tablespace MY_DATA start backup
- C、 alter tablespace MY_DATA backup begin
- D、 alter MY_DATA begin backup
- E、 You cannot back up individual tablespaces
正确答案:A -
第5题：
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode
BThe database will be mounted, and recovery must be performed on the USERS tablespace.
CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
正确答案： C解析： 暂无解析 -
第6题：
单选题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 performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
BIf you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
CIf you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
DIf you restart the database，the database will not be opened.
正确答案： C解析： 暂无解析 -
第7题：
单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）AThe RMAN backup fails because the TOOLS tablespace is read-only
BThe RMAN skips the backup of the tablespace because backup optimization is enabled
CThe RMAN makes backup because optimization can be enabled only for backups to disk
DThe RMAN makes the backup because no backup of the tablespace exists within the seven day window
正确答案： A解析： 暂无解析 -
第8题：
多选题The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command： SQL> ALTER TABLESPACE hi_data BEGIN BACKUP； Which two statements are true in this scenario？（）ANo transaction on the tablespace is allowed but you can perform queries.
BThe tablespace will automatically come out of backup mode when the file copy is complete.
CThe checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
DThe database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
正确答案： A,C解析： 暂无解析 -
第9题：
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）Aalter tablespace DAVE_TBS backup mode
Balter tablespace DAVE_TBS start backup
Calter tablespace DAVE_TBS begin backup
Dalter tablespace DAVE_TBS backup begin
Ealter tablespace DAVE_TBS backup
正确答案： B解析： 暂无解析 -
第10题：
单选题You executed the following command to perform a backup of the USERS tablespace： SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）AThe MTTR Advisor is disabled.
BThe database is in NOARCHIVELOG mode.
CThe tablespace is already in backup mode.
DThe Flash Recovery Area is not configured.
正确答案： D解析： 暂无解析 -
第11题：
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）AOnly bring the tablespace back online.
BOnly recover the tablespace and then bring the tablespace back online.
CShut down the database， recover the data file and then start up the database.
DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
正确答案： B解析： 暂无解析 -
第12题：
单选题You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）Aalter tablespace MY_DATA begin backup
Balter tablespace MY_DATA start backup
Calter tablespace MY_DATA backup begin
Dalter MY_DATA begin backup
EYou cannot back up individual tablespaces
正确答案： E解析： 暂无解析 -
第13题：
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？ （）
- A、 The database is in NOMOUNT state.
- B、 The database is in NOARCHIVELOG mode and the tablespace is online.
- C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
- D、 The database is in ARCHIVELOG mode and the tablespace is offline.
- E、 The database is in ARCHIVELOG mode and the tablespace is online.
正确答案:C,D,E -
第14题：
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）
- A、No transaction on the tablespace is allowed but you can perform queries.
- B、The tablespace will automatically come out of backup mode when the file copy is complete.
- C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
- D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
正确答案:A,C -
第15题：
In which of the following scenarios is a tablespace recovery required？（）
- A、 when recovering a lost read-only tablespace from a read-only tablespace backup
- B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG mode
- C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
- D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only
正确答案:B -
第16题：
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
- A、The database will open, and the tablespace automatically comes out of the backup mode
- B、The database will be mounted, and recovery must be performed on the USERS tablespace.
- C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
- D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
正确答案:C -
第17题：
单选题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 performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
DIf you restart the database, the database will not be opened.
正确答案： B解析： 暂无解析 -
第18题：
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）Arestore the tablespace from the backup; there is no need to apply the redo information
Brestore the full database to recover the data up to the point when you performed the backup
Crestore the tablespace from the backup， and then perform a recovery using the backup control file
Drestore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
正确答案： D解析： 暂无解析 -
第19题：
单选题To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL> ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（）AThe database will open，and the tablespace automatically comes out of the backup mode.
BThe database will be mounted，and recovery must be performed on the USERS tablespace.
CThe database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
DThe database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
正确答案： A解析： 暂无解析 -
第20题：
单选题Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）ARestore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
BRestore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
CRestore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
DRestore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
正确答案： A解析： 暂无解析 -
第21题：
单选题In which of the following scenarios is a tablespace recovery required？（）Awhen recovering a lost read-only tablespace from a read-only tablespace backup
Bwhen recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG mode
Cwhen recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
Dwhen recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only
正确答案： B解析： 暂无解析 -
第22题：
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode.
BThe database will be mounted, and recovery must be performed on the USERS tablespace.
CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
正确答案： C解析： 暂无解析 -
第23题：
多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）AThe database is in NOMOUNT state.
BThe database is in ARCHIVELOG mode and the tablespace is online.
CThe database is in ARCHIVELOG mode and the tablespace is offline.
DThe database is in NOARCHIVELOG mode and the tablespace is online.
EThe database is in NOARCHIVELOG mode and the tablespace is offline.
正确答案： D,E解析： 暂无解析 -
第24题：
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）Aalter tablespace DAVE_TBS backup mode
Balter tablespace DAVE_TBS start backup
Calter tablespace DAVE_TBS begin backup
Dalter tablespace DAVE_TBS backup begin
Ealter tablespace DAVE_TBS backup
正确答案： D解析： 暂无解析