单选题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

题目

单选题

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？（）

Image of the control file

Location of the control file

Contents of the control file in text format

SQL command to re-create the database

SQL command to re-create the control file

Contents of the control file in binary format

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A、 The command restores only the missing control file.
B、 The command restores all the control files.
C、 The command fails because the database is running.
D、 This is the correct way to address this problem.
E、 This is not the correct way to address this problem.

正确答案:C,E

第2题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically？（）

A、a tablespace is taken offline
B、the database instance is restarted
C、a new data file is added to an existing tablespace
D、a successful backup is recorded in the RMAN repository
E、the RMAN connection is disconnected from the target database

正确答案:C,D

第3题：

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion

参考答案：A

第4题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files
B、dropping a user in your database
C、enabling or disabling redo log archiving
D、dropping a tablespace in your database
E、re-creating the control files， after you lost all the control files in your database

正确答案:C

第5题：

What RMAN command must you use before you can back up a database using the recovery catalog？（）

A、 create catalog
B、 install database
C、 catalog database
D、 merge Catalog with database
E、 register database

正确答案:E

第6题：

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

A、 a list of files that require a backup within three days
B、 a list of files that have not been backed up for three days
C、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D、 a list of files for which a backup has already been performed and may need a backup after three days

正确答案:B

第7题：

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 file
B、Location of the control file
C、Contents of the control file in text format
D、SQL command to re-create the database
E、SQL command to re-create the control file
F、Contents of the control file in binary format

正确答案:E

第8题：

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

参考答案：C

第9题：

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 datafile
B、 when you drop a table from the database
C、 when you take an export of the database
D、 when you back up the database using OS utilities
E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第10题：

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 trace
B、bring database to the MOUNT state
C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

正确答案:C

You executed the following command to back up the control fi

题目

相似问题和答案

更多相关问题

相关内容