网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
- A、’SQL ALTER DATABASE OPEN’；
- B、SQL ALTER DATABASE ’OPEN’；
- C、OPEN DATABASE；
- D、DATABASE OPEN
参考答案
更多 “RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN” 相关考题
考题
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
考题
You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A、The database would open normally.B、The database would not open， and it would stop at mount stage.C、The database would open after automatically performing instance recovery.D、The database would not open， and you have to perform database recovery to open it.
考题
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
考题
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）A、All control files are openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened
考题
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
考题
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A、Open the database in NORMAL modeB、Open the database in read-only modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option
考题
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；
考题
After the recovery is complete， which command should you execute？（）A、ALTER DATABASE OPEN；B、ALTER DATABASE CLEAR LOGFILE；C、ALTER DATABASE OPEN RESETLOGS；D、ALTER DATABASE OPEN NORESETLOGS；
考题
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a， b， c， d， e， fB、 c， d， a， b， fC、 d， c， a， b， fD、 d， b， d， c， eE、 d， c， a， b， e
考题
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
Identify three valid methods of opening, pluggable databases (PDBs).（）A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbC、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD、ALTER DATABASE PDB OPEN issued from the rootE、ALTER DATABASE OPEN issued from that pdbF、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbG、ALTER PLUGGABLE DATABASE OPEN issued from that pdb
考题
Examine this statement： RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）A、The target database must be open.B、The target database must be closed.C、The target database must be mounted.D、The target database must be mounted or open.
考题
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）A、Only 1B、Only 2C、Only 3D、3 and 1E、1 and 2
考题
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA、 b， a， c， d， eB、 a， c， b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 e， a， b， d， c
考题
多选题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
单选题Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）A
Only 1B
Only 2C
Only 3D
3 and 1E
1 and 2
考题
单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A
’SQL ALTER DATABASE OPEN’；B
SQL ALTER DATABASE ’OPEN’；C
OPEN DATABASE；D
DATABASE OPEN
考题
单选题Which command is used to open the database after an incomplete recovery？（）A
alter database openB
alter database open repairlogC
alter database open resetlogsD
alter database open resetlogE
alter database resetlogs open
考题
单选题Examine this statement： RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）A
The target database must be open.B
The target database must be closed.C
The target database must be mounted.D
The target database must be mounted or open.
考题
单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A
The database would open normally.B
The database would not open， and it would stop at mount stage.C
The database would open after automatically performing instance recovery.D
The database would not open， and you have to perform database recovery to open it.
考题
单选题When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A
a， b， c， d， e， fB
c， d， a， b， fC
d， c， a， b， fD
d， b， d， c， eE
d， c， a， b， e
考题
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B
STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D
STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
单选题After the recovery is complete， which command should you execute？（）A
ALTER DATABASE OPEN；B
ALTER DATABASE CLEAR LOGFILE；C
ALTER DATABASE OPEN RESETLOGS；D
ALTER DATABASE OPEN NORESETLOGS；
考题
单选题You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL SHUTDOWN IMMEDIATE 5. Open the database： SQL ALTER DATABASE OPEN； Choose the correct sequence.（）A
4， 1， 3， 2， 5B
4， 3， 1， 2， 5C
2， 4， 3， 5， 1D
4， 2， 5， 3， 1
热门标签
最新试卷