网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
When you create a backup control file, where is the resulting file written to?()
A
The database user dump destination directory
B
The database diagnostic destination directory
C
To $ORACLE_HOME/rdbms
D
To $ORACLE_HOME/admin
E
To the directory and filename you specify in the command
参考答案
参考解析
解析:
暂无解析
更多 “单选题When you create a backup control file, where is the resulting file written to?()A The database user dump destination directoryB The database diagnostic destination directoryC To $ORACLE_HOME/rdbmsD To $ORACLE_HOME/adminE To the directory and filename you specify in the command” 相关考题
考题
What methods are available to recover lost control files?() A、 Backup control file.B、 Emergency control file.C、 The create controlfile command.D、 The restore controlfile SQL*Plus command.E、 No backup is required. The database will re-create the control file when it is discovered to be lost.
考题
In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()A、the alert log fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files
考题
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 have discovered that one of three control files has been lost. What steps would you follow to recover that control file?() a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database. A、a, b, f, gB、c, f, gC、a, d, f, gD、a, f, gE、a, e, g
考题
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 configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()A、Archiving will be disabled because the destination for the redo log files is missing.B、The database instance will shut down and the error details will be logged in the alert log file.C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
考题
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
You issued the following RMAN command: RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.
考题
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file
考题
You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST
考题
When you create a backup control file, where is the resulting file written to?() A、 The database user dump destination directoryB、 The database diagnostic destination directoryC、 To $ORACLE_HOME/rdbmsD、 To $ORACLE_HOME/adminE、 To the directory and filename you specify in the command
考题
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
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
考题
Which is not a valid way of backing up a control file?() A、 Backing up the control file to traceB、 Copying the existing control file of the database to the backup location during a hot backup C、 Copying the existing control file of the database to the backup location during a cold backupD、 Creating a backup control fileE、 Using the create controlfile command
考题
Your network contains an Exchange Server 2010 Mailbox server.The server has one mailbox database.A user named User1 reports that he has multiple corrupted e-mail messages in his mailbox.You need to recover User1ˉs -mail messages.The solution must not delete any other e-mail messages in the mailbox database.What should you do?()A、Create a new Mailbox Recovery Database, restore a backup of the database file, and then run the Export-Mailbox cmdlet.B、Create a new Mailbox Recovery Database, restore a backup of the database file, and then run the Restore-Mailbox cmdlet.C、Create a database availability group (DAG), restore a backup of the mailbox database file, and then run the Restore-Mailbox cmdlet.D、Create a database availability group (DAG), restore a backup of the mailbox database file, and then run the Export-Mailbox cmdlet.
考题
单选题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
考题
单选题Which is not a valid way of backing up a control file?()A
Backing up the control file to traceB
Copying the existing control file of the database to the backup location during a hot backup C
Copying the existing control file of the database to the backup location during a cold backupD
Creating a backup control fileE
Using the create controlfile command
考题
单选题You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()A
USER_DUMP_DESTB
CORE_DUMP_DESTC
TRACE_DUMP_DESTD
BACKUP_DUMP_DESTE
BACKGROUND_DUMP_DEST
考题
多选题In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()Athe alert log fileBthe core dump filesCthe change tracking fileDthe user session trace filesEthe database audit trail filesFthe background process trace files
考题
单选题You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()A
Image of the control fileB
Location of the control fileC
Contents of the control file in text formatD
SQL command to re-create the databaseE
SQL command to re-create the control fileF
Contents of the control file in binary format
考题
单选题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 configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files()A
Archiving will be disabled because the destination for the redo log files is missing.B
The database instance will shut down and the error details will be logged in the alert log file.C
Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.D
Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
考题
单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A
Start the instance and open the database, instance recovery automatically recoverscontrol filesB
Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A
Start the instance and open the database, instance recovery automatically recovers control files B
Create a file based on the contents of the trace file and save it to the control file locations and start the database C
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
单选题When you create a backup control file, where is the resulting file written to?()A
The database user dump destination directoryB
The database diagnostic destination directoryC
To $ORACLE_HOME/rdbmsD
To $ORACLE_HOME/adminE
To the directory and filename you specify in the command
考题
单选题You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?() a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.A
a, b, f, gB
c, f, gC
a, d, f, gD
a, f, gE
a, e, g
考题
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A
redo log filesB
password fileC
control fileD
change tracking file
考题
单选题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
热门标签
最新试卷