单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A FULLB SCHEMASC REMAP_SCHEMAD REMAP_DATAFILESE REMAP_TABLESPACE

题目
单选题
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
A

FULL

B

SCHEMAS

C

REMAP_SCHEMA

D

REMAP_DATAFILES

E

REMAP_TABLESPACE

相似考题

1.You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8

2. You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

3.You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）A、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace

4. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）A、WindowB、ProgramC、Job classD、Window group

更多“单选题You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A FULLB SCHEMASC REMAP_SCHEMAD REMAP_DATAFILESE REMAP_TABLESPACE”相关问题

  • 第1题：

    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

    • A、Perform Export before TSPITR and Import after TSPITR
    • B、Move objects to another schema that has the same tablespace assigned
    • C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
    • D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

    正确答案:A

  • 第2题：

    You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

    • A、FULL
    • B、SCHEMAS
    • C、REMAP_SCHEMA
    • D、REMAP_DATAFILES
    • E、REMAP_TABLESPACE

    正确答案:C

  • 第3题：

    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）  

    • A、 owner
    • B、 touser
    • C、 attach
    • D、 remap_schema

    正确答案:D

  • 第4题：

    You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）

    • A、FULL
    • B、SCHEMAS
    • C、TRANSFORM
    • D、REMAP_SCHEMA
    • E、REMAP_TABLESPACE

    正确答案:D

  • 第5题：

    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

  • 第6题：

    单选题
    You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）
    A

    owner

    B

    touser

    C

    include

    D

    schemas

    E

    fromuser

    F

    transform

    G

    remap_schema

    H

    remap_datafile

    I

    reuse_datafiles

    J

    remap_tablespace


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

  • 第7题：

    单选题
    You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
    A

    FULL

    B

    SCHEMAS

    C

    REMAP_SCHEMA

    D

    REMAP_DATAFILES

    E

    REMAP_TABLESPACE


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

  • 第8题：

    单选题
    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）
    A

     owner

    B

     touser

    C

     attach

    D

     remap_schema


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

  • 第9题：

    单选题
    You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）
    A

    FULL

    B

    SCHEMAS

    C

    TRANSFORM

    D

    REMAP_SCHEMA

    E

    REMAP_TABLESPACE


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

  • 第10题：

    单选题
    You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
    A

    a table name which has 100s of records

    B

    a table name which has 10s of records

    C

    a table name which has empty records

    D

    a table name which has 1000s of records

    E

    never use a table name


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

  • 第11题：

    单选题
    You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: Which option illustrates the correct sequence that you must use?（）
    A

    8, 1, 3, 2, 4, 5, 7, 6

    B

    1, 8, 3, 4, 2, 5, 7, 6

    C

    1, 3, 4, 2, 8, 5, 6, 7

    D

    1, 3, 2, 4, 6, 5, 7, 8


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

  • 第12题：

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


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

  • 第13题：

    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

    • A、 Data Pump Export and Import
    • B、 conventional export and import
    • C、 the CONVERT command of RMAN
    • D、 the BACKUP AS COPY. command of RMAN

    正确答案:D

  • 第14题：

    You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）

    • A、FULL
    • B、SCHEMAS
    • C、TRANSFORM
    • D、REMAP_SCHEMA
    • E、REMAP_TABLESPACE

    正确答案:D

  • 第15题：

    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

  • 第16题：

    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

    • A、functions
    • B、packages
    • C、procedures
    • D、database triggers
    • E、anonymous PL/SQL block

    正确答案:D

  • 第17题：

    单选题
    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
    A

    functions

    B

    packages

    C

    procedures

    D

    database triggers

    E

    anonymous PL/SQL block


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

  • 第18题：

    单选题
    In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）
    A

    Window

    B

    Program

    C

    Job class

    D

    Window group


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

  • 第19题：

    单选题
    You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）
    A

    FULL

    B

    SCHEMAS

    C

    TRANSFORM

    D

    REMAP_SCHEMA

    E

    REMAP_TABLESPACE


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

  • 第20题：

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

  • 第21题：

    单选题
    On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）
    A

    Flashback Drop

    B

    Flashback Table

    C

    Flashback Database

    D

    Flashback Version Query

    E

    Flashback Transaction Query


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

  • 第22题：

    单选题
    Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
    A

     Perform Export before TSPITR and Import after TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


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

  • 第23题：

    单选题
    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）
    A

     Data Pump Export and Import

    B

     conventional export and import

    C

     the CONVERT command of RMAN

    D

     the BACKUP AS COPY. command of RMAN


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

  • 第24题：

    单选题
    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
    A

    Perform Export before TSPITR and Import after TSPITR

    B

    Move objects to another schema that has the same tablespace assigned

    C

    Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

    D

    Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)


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

相关内容