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

You are managing the APPPROD database as a DBA which is not 

题目
单选题
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：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   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.

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

第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题：

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

  • A、V$SESSION 
  • B、V$SYSSTAT 
  • C、DBA_SEGMENTS 
  • D、V$SORT_USAGE

正确答案:D

第3题：

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

第4题：

Identify four uses of the Oracle Scheduler.（）

  • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
  • B、 enables Oracle database to do patches according to a DBA-defined schedule
  • C、 enables you to schedule the execution of jobs based on time
  • D、 enables you to execute jobs in a clustered environment
  • E、 enables you to periodically execute operating systemscript files located on the same server as the database
  • F、 enables you to create a job that makes use of saved programs and schedules
  • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

正确答案:C,D,E,F

第5题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

  • A、The database crashes.
  • B、The DBA needs to re-create the file.
  • C、The file gets re-created automatically.
  • D、The file gets restored automatically from the last backup.
  • E、The DBA needs to perform a complete database recovery.
  • F、The DBA needs to perform an incomplete database recovery.

正确答案:C

第6题：

Which view will you use to view information regarding the jobs that are currently running in a database？（）

  • A、DBA_SCHEDULER_RUNNING_JOBS
  • B、DBA_SCHEDULER_JOB_RUN_DETAILS
  • C、DBA_SCHEDULER_JOBS
  • D、DBA_SCHEDULER_JOB_LOG

正确答案:A

第7题：

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

第8题：

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

第9题：

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

  • A、The backups would be consistent.
  • B、The backups would be inconsistent.
  • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
  • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
  • E、The backups need to be restored and the database has to be recovered in case of a media failure

正确答案:B,C,E

第10题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

  • A、 Enable Flashback Data Archive for the tables.
  • B、 Specify undo retention guarantee for the database.
  • C、 Enable supplemental logging for the database.
  • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
  • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

正确答案:A

更多相关问题
相关内容