违法和不良信息举报 联系客服
免费注册 登录

In your database, the flash rec

题目

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

  • A、Only one channel is allocated and the backup is created in the flash recovery area
  • B、Only one channel is allocated and the backup is created in the destination specified for channel 1
  • C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
  • D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

  • A、 V$FLASHBACK_DATABASE_LOG
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$DATABASE
  • D、 V$UNDOSTAT

正确答案:A

第2题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  • A、 Flash back all the tables in the data file， one by one.
  • B、 Restore the data file to a new location and perform a media recovery.
  • C、 Flash back the database， there is no need to restore the data file.
  • D、 Restore the data file from the most recent backup and flash the database.

正确答案:B

第3题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  • A、flash back all the tables in the data file， one by one
  • B、restore the data file to a new location and perform a media recovery
  • C、flash back the database; there is no need to restore the data file
  • D、restore the data file from the most recent backup and flash back the database

正确答案:B

第4题：

单选题
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
A

 V$FLASHBACK_DATABASE_LOG

B

 V$FLASHBACK_DATABASE_STAT

C

 V$DATABASE

D

 V$UNDOSTAT


正确答案： A
解析： 暂无解析

第5题：

You executed the following query in your database：  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

正确答案:D

第6题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

  • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
  • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
  • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
  • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

正确答案:A

第7题：

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.

正确答案:D

第8题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

  • A、flash back the database
  • B、perform point-in-time recovery
  • C、perform a full database recovery
  • D、drop and re-create the tablespace
  • E、use Recovery Manager （RMAN） to recover the database

正确答案:D

第9题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

  • A、 V$DATABASE
  • B、 V$UNDOSTAT
  • C、 V$FLASHBACK_DATABASE_LOG
  • D、 V$FLASHBACK_DATABASE_STAT

正确答案:C

第10题：

单选题
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
A

 Enable the flash recovery area and specify it as the archived redo log destination.

B

 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

C

 Enable the flash recovery area but do not specify it as the archived redo log destination. 

D

 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


正确答案： B
解析： 暂无解析

更多相关问题
相关内容