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

题目
多选题
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: RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;   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.


相似考题
更多“You are working on a CATDB database that contains an Oracle ”相关问题
  • 第1题:

    You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance, the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information?()

    • A、It gets it from the parameter file.
    • B、The listener prompts for details on startup.
    • C、The listener gathers information from the control file.
    • D、The instance automatically registers with the default listener.
    • E、The listener gets this information through thelistener.orafile.

    正确答案:D,E

  • 第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题:

    In which two cases would you perform only consistent backup?()

    • A、You are working on a database where downtime is not tolerated.
    • B、You are working on a database where downtime can be tolerated.
    • C、You are working on a database that operates in ARCHIVELOG mode.
    • D、You are working on a database that operates in NOARCHIVELOG mode.
    • E、You are working on a database where all the tablespaces are locally managed.
    • F、You are working on a database where control files and redo log files are multiplexed.
    • G、You are working on a database where control files and redo log files are not multiplexed.

    正确答案:B,D

  • 第4题:

    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: RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;   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

  • 第5题:

    You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()

    • A、 SYSDATE should not be used with TIMESTAMP.
    • B、 The database must have multiplexed redo log files.
    • C、 The database must be in the MOUNT state to execute the command.
    • D、 The database must be opened with the RESETLOGS option after the flashback operation.
    • E、 The entire database needs to be restored from the most recent backup before the flashback operation.

    正确答案:C,D

  • 第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 about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

  • 第8题:

    多选题
    You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.  Which two statements are true about differential incremental backups()
    A

    The backup performed on Sundays contains all the blocks that have ever been used in the database.

    B

    The backup performed on Sundays contains all the blocks that have changed since the last level 1backup.

    C

    The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.

    D

    The backup performed on Monday contains all the blocks that have changed since the level 0 backup,and every other working day contains all the blocks that have changed since the level 1 backup.


    正确答案: C,D
    解析: 暂无解析

  • 第9题:

    单选题
    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 also want to deregister them from the catalog after import. You executed the following commands to achieve this:   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?()
    A

     The scripts in the RCO11 catalog are overwritten.

    B

     RMAN renames the local stored scripts in the RCO11 catalog.

    C

     The RMAN session in which the command is executed aborts.

    D

     RMAN renames the global scripts that are imported from the RCAT10 catalog.


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

  • 第10题:

    单选题
    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
    解析: 暂无解析

  • 第11题:

    单选题
    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
    解析: 暂无解析

  • 第12题:

    单选题
    How can you configure High Availability for interacting with a non-Oracle database using WebLogic?()
    A

    Configure multiple physical data sources and reuse the same JNDI name for each.

    B

    Use the compatibility option of Active GridLink to enable compatibility with non-Oracle  databases.

    C

    Configure a single physical data source for each node in a database cluster and wrap it using  Multi Data Source.

    D

    Configure a Data Source Group that contains a physical connection pool to each node in the  database cluster.


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

  • 第13题:

    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

  • 第14题:

    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 also want to deregister them from the catalog after import. You executed the following commands to achieve this:   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?()

    • A、 The scripts in the RCO11 catalog are overwritten.
    • B、 RMAN renames the local stored scripts in the RCO11 catalog.
    • C、 The RMAN session in which the command is executed aborts.
    • D、 RMAN renames the global scripts that are imported from the RCAT10 catalog.

    正确答案:D

  • 第15题:

    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.

    正确答案:D,E

  • 第16题:

    When you create a backup control file, where is the resulting file written to?()  

    • A、 The database user dump destination directory
    • B、 The database diagnostic destination directory
    • C、 To $ORACLE_HOME/rdbms
    • D、 To $ORACLE_HOME/admin
    • E、 To the directory and filename you specify in the command

    正确答案:E

  • 第17题:

    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 RMAN commands: RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1; What happens when you execute the above commands?()

    • A、They deregister all databases registered in the RCAT10 catalog.
    • B、They import metadata for all registered databases in the RCAT10 database.
    • C、They register all the RCAT10-catalog registered databases in the RCO11 catalog.
    • D、They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

    正确答案:A,B,C

  • 第18题:

    In a new installation of Oracle Database 11g, you perform these activities:  1:Organize software and data on different subdirectories to avoid poor performance.  2:Use consistent naming conventions for database files.  3:Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed()

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture
    • E、Automatic Storage Management

    正确答案:C

  • 第19题:

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()
    A

     Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第20题:

    多选题
    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
    解析: 暂无解析

  • 第21题:

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


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

  • 第22题:

    多选题
    You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24);  Which two statements are true? ()
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

    The database must be in the MOUNT state to execute the command.

    D

    The database must be opened with the RESETLOGS option after the flashback operation.

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


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

  • 第23题:

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第24题:

    多选题
    In which two cases would you perform only consistent backup?()
    A

    You are working on a database where downtime is not tolerated.

    B

    You are working on a database where downtime can be tolerated.

    C

    You are working on a database that operates in ARCHIVELOG mode.

    D

    You are working on a database that operates in NOARCHIVELOG mode.

    E

    You are working on a database where all the tablespaces are locally managed.

    F

    You are working on a database where control files and redo log files are multiplexed.

    G

    You are working on a database where control files and redo log files are not multiplexed.


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