You are managing an Oracle Database 10g database that uses O

题目
单选题
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()
A

 One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.

B

 One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.

C

 One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.

D

 One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.

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

第1题:

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

第2题:

You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第3题:

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()

A. The source database backup must be copied over the net for test database.

B. The source database must be run in ARCHIVELOG mode if the database is open.

C. The source database must be shut down cleanly if the database is in mounted state.

D. A net service name should be set up and a listener configured with the target as well as the source database.


参考答案:B, C, D

第4题:

You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs?()

  • A、 LGWR
  • B、 DBWR
  • C、 MMON
  • D、 RVWR

正确答案:D

第5题:

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

第6题:

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第7题:

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()

  • A、The Oracle kernel will be placed in this location.
  • B、The Oracle software will be placed in this location.
  • C、The server parameter file (SPFILE) will be placed in this location.
  • D、The database files will be placed in this location, if not specified explicitly.
  • E、The location will be considered for the base of Oracle Managed Files (OMF).
  • F、The location will be considered for the base of Optimal Flexible Architecture (OFA).

正确答案:F

第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 want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()

  • A、SQL*Plus
  • B、iSQL*Plus
  • C、Management Server
  • D、Management Repository
  • E、Oracle Enterprise Manager 10g Database Control

正确答案:E

第10题:

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

更多相关问题