网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）
A
A text copy of the control file.
B
A binary copy of the control file.
C
A file containing a SQL statement which will re-create the database.
D
A file containing a SQL statement which will re-create the control file.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A A text copy of the control file.B A binary copy of the control file.C A file containing a SQL statement which will re-create the database.D A file containing a SQL statement which will re-create the control file.” 相关考题
考题
RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）A、 TrueB、 False
考题
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
考题
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
考题
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
考题
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB、Make a copy of the control file with the database shut downC、Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD、Make a copy of the control file with the database still running
考题
You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（） A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
考题
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
考题
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（） A、 ALTER SYSTEM KILL SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
考题
What command would you issue to enable automated backups of control files? （）A、alter database controlfile autobacku onB、alter system controlfile autobackup on C、configure controlfile autobackup on D、enable controlfile autobackup
考题
Which command will result in a trace file being created with the create controlfile command contained in it？（） A、 alter database backup controlfileB、 alter database backup controlfile to traceC、 alter database controlfile backupD、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E、 alter database begin controlfile backup
考题
In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing
考题
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
单选题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？（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database，the database will not be opened.
考题
单选题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?（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
考题
单选题In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A
when all the control files are missing and only a binary backup of the current control file existsB
when a multiplexed copy of the current control file is missingC
when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD
when the SPFILE is missing
考题
单选题You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）A
The control file will be multiplexed.B
The control file will be recreated.C
The script containing the CREATE CONTROLFILE statement will be created.D
The binary backup of the control file will be created.
考题
单选题ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A
Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB
Make a copy of the control file with the database shut downC
Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD
Make a copy of the control file with the database still running
考题
单选题RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）A
TrueB
False
考题
单选题Which command will result in a trace file being created with the create controlfile command contained in it？（）A
alter database backup controlfileB
alter database backup controlfile to traceC
alter database controlfile backupD
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E
alter database begin controlfile backup
考题
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A
A text copy of the control file.B
A binary copy of the control file.C
A file containing a SQL statement which will re-create the database.D
A file containing a SQL statement which will re-create the control file.
考题
单选题Which command will result in a trace file being created with the create controlfile command contained in it?（）A
alter database backup controlfileB
alter database backup controlfile to traceC
alter database controlfile backupD
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E
alter database begin controlfile backup
考题
单选题What command would you issue to enable automated backups of control files？（）A
alter database controlfile autobackup onB
alter system controlfile autobackup onC
configure controlfile autobackup onD
enable controlfile autobackup
考题
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
考题
单选题Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）A
ALTER SYSTEM KILL SESSIONB
ALTER SYSTEM DISCONNECT SESSIONC
ALTER SYSTEM QUIESCE RESTRICTEDD
ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
单选题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
考题
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
热门标签
最新试卷