网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）
A
shutdown restore datafile 4； recover datafile 4； alter database open；
B
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
C
Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
D
Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
E
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A shutdown restore datafile 4； recover datafile 4； alter database open；B Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；” 相关考题
考题
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）1.Shut down the database.2.Take the users_01.dbf datafile offline with the alter database command.3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.4.Restore all users tablespace-related datafiles from backup media.5.Issue the recover tablespace users command.6.Issue the recover datafile users_01.dbf command.7.Start up the database.8.Bring the users_01.dbf datafile online with the alter database command.A.1，3，6，7B.2，3，6，8C.1，2，3，6，7D.1，2，3，6，，7，8E.2，3，6，5，7
考题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?（）A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
考题
You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.A、a， c， f， gB、b， d， e， hC、a， b， c， f， gD、d， a， e， gE、b， c， f， e， g
考题
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.A、1，3，6，7B、2，3，6，8C、1，2，3，6，7D、1，2，3，6，，7，8E、2，3，6，5，7
考题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（） A、 shutdown restore datafile 4； recover datafile 4； alter database open；B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
Which of the following commands cannot be executed when the database open？（）A、RECOVER DATABASEB、RECOVER TABLESPACEC、RECOVER DATAFILED、ALTER DATABASE RECOVER DATAFILE
考题
What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（） a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4 d. sql ’alter database datafile 4 offline’ e. startup f. shutdownA、 a， c， b， dB、 d， b， c， aC、 f， d， b， c， a， eD、 c， a， b， d， fE、 a， b， d， e
考题
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（） A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.
考题
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
考题
Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command. A、a， c， f， gB、b， c， f， hC、a， b， c， f， gD、a， b， c， f， g， hE、b， c， f， e， g
考题
What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A、 Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B、 The restore command will fail.C、 The recover command will fail.D、 The alter database open resetlogs command will fail.E、 All these commands will fail because they must be in the confines of a run block.
考题
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）A、a， b， e， cB、b， e， dC、a， b， d， cD、b， g， c， fE、a， b， d， f
考题
单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）A
Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B
Oracle will automatically take the datafile out of hot backup mode and then open the database.C
Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D
The database will open with the file in hot backup mode. You can restart the backup at any time.E
The datafile in hot backup mode will be corrupted and you will have to recover it.
考题
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
单选题Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.A
a， c， f， gB
b， c， f， hC
a， b， c， f， gD
a， b， c， f， g， hE
b， c， f， e， g
考题
单选题You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.A
a， c， f， gB
b， d， e， hC
a， b， c， f， gD
d， a， e， gE
b， c， f， e， g
考题
单选题Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.A
1，3，6，7B
2，3，6，8C
1，2，3，6，7D
1，2，3，6，，7，8E
2，3，6，5，7
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A
Restore and recover the datafile. B
Restore and recover the tablespace. C
Restore and recover the database. D
Restore and recover the control file. E
Restore and recover the parameter file.
考题
单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A
shutdown restore datafile 4； recover datafile 4； alter database open；B
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C
Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D
Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A
Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B
The restore command will fail.C
The recover command will fail.D
The alter database open resetlogs command will fail.E
All these commands will fail because they must be in the confines of a run block.
考题
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A
The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B
The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C
The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D
The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
考题
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A
Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B
Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C
Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D
Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）A
Restore and recover the datafile.B
Restore and recover the tablespace.C
Restore and recover the database.D
Restore and recover the control file.E
Restore and recover the parameter file.
考题
单选题Which of the following commands cannot be executed when the database open？（）A
RECOVER DATABASEB
RECOVER TABLESPACEC
RECOVER DATAFILED
ALTER DATABASE RECOVER DATAFILE
考题
单选题What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（） a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4 d. sql ’alter database datafile 4 offline’ e. startup f. shutdownA
a， c， b， dB
d， b， c， aC
f， d， b， c， a， eD
c， a， b， d， fE
a， b， d， e
考题
单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）A
a， b， e， cB
b， e， dC
a， b， d， cD
b， g， c， fE
a， b， d， f
热门标签
最新试卷