Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、sy

题目

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

  • A、archival
  • B、log writer
  • C、database writer
  • D、system monitor
  • E、process monitor
  • F、change tracking writer
相似考题

1.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

2.When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）A、The database has a subset of the tables in the production server database.B、The database has a copy of selected data from the production databaseC、The database logs changes for later propagation.D、The database is accessed as read-only to prevent data corruption.E、The database includes all user and order data for offline processing.

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.A staging server is critical for an administrator to test updates without introducing risk into a production environment.  Which of the following steps should an administrator take to test on a staging server？（）A、Create and Configure a WebSphere Commerce Instance on the staging serverB、Run the Stage Copy Utility to copy production server data into the staging server.C、Run the Stage Propagate Utility to propagate the staging server with production server data D、Create and configure a Staging database

更多“Your production data”相关问题

  • 第1题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第2题：

    多选题
    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）
    A

    The database has a subset of the tables in the production server database.

    B

    The database has a copy of selected data from the production database

    C

    The database logs changes for later propagation.

    D

    The database is accessed as read-only to prevent data corruption.

    E

    The database includes all user and order data for offline processing.


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

  • 第3题：

    单选题
    You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

     mount the new disk group in the ASM instance

    B

     restart the ASM instance and the production database instance

    C

     register the new disk groups in the production database instance

    D

     restart the ASM instance without restarting the production database instance

    E

     include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


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

  • 第4题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


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

  • 第5题：

    单选题
    You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）
    A

    Use the database link.

    B

    Use the SQL*Loader utility.

    C

    Use the Oracle Data Pump utility.

    D

    Create an external table and leave the data in the flat file


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

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


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

  • 第7题：

    单选题
    You need to design a monitoring strategy to meet business requirements for data on servers in the production department. What should you do？（）
    A

    Use the Microsoft Baseline Security Analyzer （MBSA） to scan for Windows vulnerabilities on all servers in the production department

    B

    Run Security and Configuration Analysis to analyze the security settings of all servers in the production department

    C

    Enable auditing for data on each server in the production department. Run System Monitor on all servers in the production department to create a counter log that tracks activity for the Objects performance object

    D

    Create a Group Policy Object （GPO） that enables auditing for object access and link it to the product department’s Servers OU. Enable auditing for data on each server in the production department


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

  • 第8题：

    单选题
    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


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

  • 第9题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


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

  • 第10题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

  • 第11题：

    单选题
    ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）
    A

    Use the database link.

    B

    Use the SQL*Loader utility.

    C

    Use the Oracle Data Pump utility.

    D

    Create an external table and leave the data in the flat file


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

  • 第12题：

    单选题
    In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.  Whataction would you take to achieve this task（）
    A

    Apply fine-grained auditing.

    B

    Implement value-based auditing.

    C

    Impose standard database auditing to audit object privileges.

    D

    Impose standard database auditing to audit SQL statements.


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

  • 第13题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


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

  • 第14题：

    单选题
    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
    A

    Open the database in NORMAL mode

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


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

  • 第15题：

    单选题
    You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）
    A

    Upgrade the hardware/memory to accommodate the data.

    B

    Load the data into your database by using the PARALLEL clause.

    C

    Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.

    D

    Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.


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

  • 第16题：

    单选题
    A customer has an IBM System Storage Enterprise Storage Server and several EMC CX3 systems installed in a data center， attached to IBM System p servers. As a step toward data consolidation， they intend to put all data on a new DS8700.  What would be the most important data migration factors to consider（）
    A

    sector size and the amount of production data

    B

    existing RAID levels and the disk drive speed

    C

    sector size and existing RAID levels

    D

    amount of production data and the disk drive speed


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

  • 第17题：

    单选题
    In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）
    A

     Complete Recovery with online redo log

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


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

  • 第18题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

相关内容