You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

相似题目

• ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）

  A . parallel image copy backup  B . backup with MAXPIECESIZE configured for the channel  C . parallel backup with MAXPIECESIZE configured for the channel  D . intrafile parallel backu

  查看最佳答案

• You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use？（）

  A . Only host B . Only local C . Either host or local D . Both host and local

  查看最佳答案

• 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.

  查看最佳答案

• Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）

  A .  Oracle Net Manager B .  Listener Control utility C .  Database Configuration Assistant D .  Oracle Net Configuration Assistant

  查看最佳答案

• You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

  A . BFILE  B . REF column  C . Object table  D . Column object  E . INSTEAD-OF trigger

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

  查看最佳答案

• You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

  查看最佳答案

• You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

  A . When the instance is started  B . When the database is mounted  C . When the database is opened  D . When the database is closed

  查看最佳答案

• 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.

  查看最佳答案

• 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.

  查看最佳答案

• You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

  A .  The au_size disk group attribute determines the size of allocation units in the disk group.  B .  The allocation unit size may vary but the extent size is fixed. C .  The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed. D .  Extent management is completely automated.

  查看最佳答案

• You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

  A . Set the UNDO_RETENTION parameter to 900 or more. B . Create an initial undo segment in the undo tablespace. C . Enable the retention guarantee for the undo tablespace. D . Set the UNDO_TABLESPACE parameter to UNDO_TBS1. E . Set the UNDO_MANAGEMENT initialization parameter to AUTO.

  查看最佳答案

• You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

  A . Multiplex all database files B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter.

  查看最佳答案

• You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery 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.

  查看最佳答案

• 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

  查看最佳答案

• our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

  A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

  查看最佳答案

• Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

  A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

  查看最佳答案

• 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.

  查看最佳答案

• You are speaking to an IT manager with 350 small servers. The IT manager is looking to reduce and consolidate systems.  What strategy would you follow？（）

  A . Tell the customer that IBM has the best scale-out server strategy. B . Show the benefit of server consolidation with IBM and the return on investment. C . Find out the mixture of server processor and application type. D . Tell the customer to buy smaller servers.

  查看最佳答案

• You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）

  A . parallel image copy backup B . backup with MAXPIECESIZE configured for the channel C . parallel backup with MAXPIECESIZE configured for the channel D . intrafile parallel backu

  查看最佳答案

• You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

  A . Multiplex all database files. B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter

  查看最佳答案

• You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

  A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.

  查看最佳答案

• You are designing an organizational unit （OU） structure to manage the New App servers.  What should you do？ （）

  A .  Create one OU that includes both the web servers and the database servers. B .  Create one OU that includes the web servers and one OU that includes the database servers. C .  Create one OU that includes the web servers. Then Place the database servers in the Computer Containers. D .  Place the web server and the database servers in the Domain Controller OU.

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  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.

  查看最佳答案