You are connected to...

多项选择题You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？（）

A. the alert log file
B. the server parameter file
C. the formatted name of a control file autobackup
D. an RMAN session log file
E. the trace file

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题In which two conditions are resumable statements suspended？（）

A. when a user exceeds the space quota
B. when a user session is terminated
C. when a table that is being accessed by the current transaction is not found
D. when a user manually suspends the statement
E. when the maximum extents of a segment is reached

点击查看答案

2.多项选择题 View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；
Which three types of files are backed up？（）

A. all the data files belonging to the USERS tablespace
B. password file
C. online redo log files
D. the current control file
E. archived redo log files
F. the current server parameter file
G. data files belonging to the USERS tablespace and all the default tablespaces

点击查看答案

3.单项选择题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group

点击查看答案

4.单项选择题The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

A. a list of all those files that have been deleted in the last two days
B. a list of all those files that have been recovered within the last two days
C. a list of all the expired backups and copies
D. a list of backups and copies that are outside the range covered by the current retention policy

点击查看答案

5.单项选择题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

A. RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
B. RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
C. RMAN would relocate all the database files to an ASM disk group.
D. RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

点击查看答案

6.单项选择题On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

A. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

点击查看答案

7.多项选择题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer

点击查看答案

8.单项选择题You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically

点击查看答案

9.单项选择题 You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’，
COMMENT => ’New Group’）；
This command errors out displaying the following message：
ERROR at line 1：
ORA-29371： pending area is not active
ORA-06512： at "SYS.DBMS_RMIN"， line 115
ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108
ORA-06512： at line 1
What action would you take to overcome this error？（）

A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area

点击查看答案

10.单项选择题You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）

A. FREQ = MONTHLY； BYDAY = 2FRI；
B. FREQ = MONTHLY； BYDAY = FRI（2）；
C. FREQ = MONTHLY； BYDAY = FRI2；
D. FREQ = MONTHLY； BYDAY = -2FRI；

点击查看答案