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 dat

题目

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.
相似考题

1.Which three components does the Scheduler use for managing tasks within the Oracle environment?()A. a jobB. a programC. a scheduleD. a PL/SQL procedure

2.Which three components does the Scheduler use for managing tasks within the Oracle environment? ()(Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedure

3.—You work for a small chain of clothing stores. The Managing Director has asked you to write a short report on last month's performance.—Look at the charts and table below, on which you have already made some handwritten notes.—Then, using all your handwritten notes, write the report for your Managing Director—Write 120-140 words.

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

更多“You are managing an Oracle Datab”相关问题

  • 第1题：

    You are configuring for Oracle Shared Server. Which service is required？ （）

    • A、Oracle Net Service
    • B、Oracle HTTP Service
    • C、Oracle Paging Service
    • D、Internet Directory Service

    正确答案:A

  • 第2题：

    You are working on a debug build of an application.You need to find the line of code that caused an exception to be thrown. Which property of the Exception class should you use to achieve this goal？（）

    • A、Data
    • B、Message
    • C、Stack Trace
    • D、Source

    正确答案:C

  • 第3题：

    Which three components does the Scheduler use for managing tasks within the Oracle environment? （）(Choose three.)

    • A、a job
    • B、a program
    • C、a schedule
    • D、a PL/SQL procedure

    正确答案:A,B,C

  • 第4题：

    When you use WebLogic Management Pack EE, which three operations are enabled compared to managing WebLogic Server only through web console?（）

    • A、management of many WebLogic Server Domains from a single web console
    • B、tracking changes in the configuration of WebLogic Domain
    • C、automation of provisioning process in the new environment
    • D、checking compliance with the licenses that a customer has
    • E、visual creation of JDBC DataSource object to Oracle RAC

    正确答案:A,B,E

  • 第5题：

    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

    • A、Oracle Flashback uses undo information to construct consistent data. 
    • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
    • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
    • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

    正确答案:A,B

  • 第6题：

    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

    正确答案:B

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


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

  • 第8题：

    单选题
    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 backup


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

  • 第9题：

    单选题
    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.


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

  • 第10题：

    单选题
    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


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

  • 第11题：

    多选题
    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


    正确答案： D,E
    解析： 暂无解析

  • 第12题：

    单选题
    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；


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

  • 第13题：

    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

  • 第14题：

    Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）

    • A、 If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local & global transactions
    • B、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMS
    • C、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic Server
    • D、 If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions

    正确答案:B,D

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Which three components does the Scheduler use for managing tasks within the Oracle environment?（）

    • A、a job
    • B、a program
    • C、a schedule
    • D、a PL/SQL procedure

    正确答案:A,B,C

  • 第18题：

    多选题
    Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）
    A

    If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local & global transactions

    B

    Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMS

    C

    Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic Server

    D

    If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions


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

  • 第19题：

    单选题
    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


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

  • 第20题：

    单选题
    You 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 channe

    D

     intrafile parallel backup


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

  • 第21题：

    多选题
    When you use WebLogic Management Pack EE, which three operations are enabled compared to managing WebLogic Server only through web console?（）
    A

    management of many WebLogic Server Domains from a single web console

    B

    tracking changes in the configuration of WebLogic Domain

    C

    automation of provisioning process in the new environment

    D

    checking compliance with the licenses that a customer has

    E

    visual creation of JDBC DataSource object to Oracle RAC


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

  • 第22题：

    单选题
    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.


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

  • 第23题：

    单选题
    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 backup


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

  • 第24题：

    多选题
    You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）
    A

    Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

    B

    Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

    C

    Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

    D

    Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.


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

相关内容