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

You are working on the APPDB database as a DBA. The database

题目
单选题
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）
A

The Flashback Archive FLA1 is dropped only if it is empty.

B

The tablespace having Flashback Archive is dropped.

C

The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.

D

The Flashback Data Archive and historical data are dropped.

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

第1题：

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案：B, C, E

第2题：

You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

  • A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
  • B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

正确答案:A

第3题：

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?（）

A. They import all metadata from the RCAT10 catalog.

B. They unregister the database from the RCAT10 catalog.

C. They do not register the databases registered in the RCAT10 catalog.

D. They register all databases registered in the RCAT10 catalog.


参考答案：A, D

第4题：

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area （FRA） for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

第5题：

You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）

  • A、The database performance would be enhanced.
  • B、The redo log files would be get filled more frequently.
  • C、The overall database performance would be degraded.
  • D、The mean time to recover （MTTR） would be increased.

正确答案:C

第6题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第7题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

  • A、 The Flashback Archive FLA1 is dropped only if it is empty.
  • B、 The tablespace having Flashback Archive is dropped.
  • C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  • D、 The Flashback Data Archive and historical data are dropped.

正确答案:D

第8题：

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


参考答案：B

第9题：

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

第10题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

  • A、You can perform consistent backups only.
  • B、You can perform a complete database backup without shutting down the database instance.
  • C、You can back up data files only when all data files have the same SCN recorded in the control file.
  • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

正确答案:B,D

更多相关问题
相关内容