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 productio

题目

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

1.You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming

2. You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline

3. Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；

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 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 productio”相关问题

  • 第1题：

    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

    • A、Use the introspect () command in WLST to gather the configuration information from the  original domain.
    • B、Use pack/unpack to transfer the domain from one machine to another.
    • C、Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.
    • D、Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.

    正确答案:C

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

    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）

    • A、profile
    • B、account lock
    • C、account unlock
    • D、password expire
    • E、quota 10MB on TBS1
    • F、password never expire
    • G、default tablespace TBS1
    • H、quota unlimited on TBS1
    • I、temporary tablespace TEMP
    • J、temporary tablespace SYSTEM

    正确答案:D,E,G

  • 第5题：

    You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）

    • A、Host naming
    • B、Local naming
    • C、Easy Connect
    • D、External naming
    • E、directory naming

    正确答案:E

  • 第6题：

    You are the administrator of your company's network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit (OU). You create a Windows Installer package file for the service pack. You then use the package file to successfully install the service pack to other computers in the domain. You assign the package file to the Development OU.    After the installation, you notice that the service pack was not installed on any of the 10 computers. You want to ensure that the service pack is successfully installed on the Computers in the Development OU. What should you do? （）

    • A、Use Computer Management to start the Windows Installer service on all of the computers in  the Development OU
    • B、Use the local Administrator account to log on to the Computers in the Development OU. Then  redeploys the service pack to the computers in the Development OU
    • C、Run WinINSTALL LE to repair the package file. Then redeploys the service pack to the  computers in the Development OU
    • D、Add the user accounts from the Development OU to the DACL. Grant the user accounts  Read permission to the service pack deployment directory.

    正确答案:B

  • 第7题：

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

  • 第8题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


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

  • 第9题：

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

  • 第10题：

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

  • 第11题：

    多选题
    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）
    A

    profile

    B

    account lock

    C

    account unlock

    D

    password expire

    E

    quota 10MB on TBS1

    F

    password never expire

    G

    default tablespace TBS1

    H

    quota unlimited on TBS1

    I

    temporary tablespace TEMP

    J

    temporary tablespace SYSTEM


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

  • 第12题：

    单选题
    Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）
    A

    User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；

    B

    User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；

    C

    User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；

    D

    User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；

    E

    User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；


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

  • 第13题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

    • A、 Top SQL
    • B、 snapshots
    • C、 SQL Tuning sets
    • D、 index access path
    • E、 optimizer statistics
    • F、 materialized view logs

    正确答案:A,C,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 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

  • 第16题：

    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. 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

    正确答案:B

  • 第17题：

    You need to design a migration path for migrating user accounts and mailboxes to the new environment. Which two actions should you perform？（）

    • A、Use the Migration Wizard to create and migrate mailboxes to Exchange Server 2003
    • B、Use Active Directory Users and Computers to move user accounts and mailboxes to the new environment
    • C、Use Microsoft Identity Integration Server （MIIS） to synchronize user accounts with the new environment
    • D、Use the Active Directory Migration Tool （ADMT） to clone user accounts in Active Directory
    • E、Use ClonePrincipal to migrate user accounts to the new environment

    正确答案:A,D

  • 第18题：

    You are the administrator of your company’s network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit. You create a Windows 2000 installer package file for the service pack.  You use the package file o successfully install the service pack to other computers in the domain. You assign the package file to the Development organizational unit. After the installation, you notice that the service pack was not installed on any of the 10 computers. You want to ensure that the service pack is successfully installed on the computers in the Development organizational unit.  What should you do?（）

    • A、 Use Computer Management to start the Windows installer service on all the computers in the  Development organizational unit 
    • B、 Use the local administrator account to log on to the computers in the Development   organizational unit. Then redeploy the service pack to the computers in the Development organizational unit. 
    • C、 Run Windows Installer to repair the package file. Then redeploy the service pack to the   computers in the Development organizational unit. 
    • D、 Add the user accounts from the Development organizational unit to a DACL. Grant the user   accounts read permission to the service pack deployment directory.

    正确答案:D

  • 第19题：

    单选题
    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）
    A

    Use the introspect () command in WLST to gather the configuration information from the  original domain.

    B

    Use pack/unpack to transfer the domain from one machine to another.

    C

    Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.

    D

    Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

    单选题
    You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. 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
    解析： 暂无解析

  • 第23题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

相关内容