In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）..

第1题

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

点击查看答案

第2题

[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database B、Your database must be running in NOARCHIVELOG mode C、To back up a tablespace, it must be in backup mode D、To back up a tablespace, it must first be taken offline

点击查看答案

第3题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

第4题

[] 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?（） 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 product

A、A. Open the database in NORMAL mode B、B. Open the database in read-only mode C、C. Open the database in RESTRICTED mode D、D. Open the database with the RESETLOGS option

点击查看答案

第5题

[] You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（） You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、A.the time when the last flashback operation in your database was performed B、B.the time when the first flashback operation in your database was performed C、C.a list of flashback operations performed in your database using SCN and time D、D.the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案

第6题

[单选题] You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database B、Open the database in NORMAL mode C、Open the database in RESTRICTED mode D、Open the database with the RESETLOGS option

点击查看答案

第7题

[单选题] You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database B、Open the database in NORMAL mode C、Open the database in RESTRICTED mode D、Open the database with the RESETLOGS option

点击查看答案

第8题

[单选题] For which database operation would you need the database to be in the MOUNT state（）

A、renaming the control files B、re-creating the control files C、dropping a user in your database D、dropping a tablespace in your database E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

点击查看答案

第9题

[单选题] You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、 The time when the last flashback operation in your database was performed. B、 The time when the first flashback operation in your database was performed. C、 A list of flashback operations performed in your database using SCN and time. D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

点击查看答案

第10题

[多选题] You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A、Reregistering the target database in recovery catalog B、Transporting the new tablespaces to the recovery catalog database C、Syncronizing the recovery catalog with the target database control file D、Performing a fresh backup of the target database to include the new data files in the catalog database

点击查看答案

请使用微信扫码支付