单选题In the event of a failure, what would be the MOST complete method for recovering the WebSphere Commerce database?()A Recreate the database from the staging server.B Restore a database backup.C Reload the data using Mass Loader.D Republish the store arc

题目
单选题
In the event of a failure, what would be the MOST complete method for recovering the WebSphere Commerce database?()
A

Recreate the database from the staging server.

B

Restore a database backup.

C

Reload the data using Mass Loader.

D

Republish the store archive.

E

Republish from WebSphere Catalog Manager.


相似考题
更多“单选题In the event of a failure, what would be the MOST complete method for recovering the WebSphere Commerce database?()A Recreate the database from the staging server.B Restore a database backup.C Reload the data using Mass Loader.D Republish the store arc”相关问题
  • 第1题:

    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.

    正确答案:B,C

  • 第2题:

    A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database?()

    • A、Extractor, ID Resolver, XML Transformer, Mass Loader
    • B、ID Resolver, Text Transformer, Mass Loader
    • C、Text Transformer, XML Transformer, ID Resolver, Mass Loader
    • D、XML Transformer, ID Resolver, Mass Loader
    • E、XML Transformer, Mass Loader, ID Resolver

    正确答案:C

  • 第3题:

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation?()

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第4题:

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()

    • A、 Flash back all the tables in the data file, one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database, there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第5题:

    You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()

    • A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
    • B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
    • C、Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data.
    • D、Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data, and to insert the data into the database.

    正确答案:C

  • 第6题:

    单选题
    In the Configuration Manager, under the WebSphere Commerce Instance Properties, what is the Payments panel used for? It allows an Administrator to:()
    A

    drop and re-create the WebSphere Commerce Payments database.

    B

    stop and start the Payment Engine.

    C

    configure WebSphere Commerce Server communication with WebSphere Commerce Payments Server.

    D

    specify what type of Database software will be used for the WebSphere Commerce Payments database.


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

  • 第7题:

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

  • 第8题:

    单选题
    You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()
    A

    Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.

    B

    Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.

    C

    Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data.

    D

    Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data, and to insert the data into the database.


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

  • 第9题:

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.

    C

    Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.

    D

    Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online


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

  • 第10题:

    单选题
    Which of the following products and utilities can be used to update all encrypted data as well as the merchant key in a WebSphere Commerce database for a given instance?()
    A

    The Database Update Tool found in Configuration Manager

    B

    The LDAP Server

    C

    The WebSphere Application Server Administrative Console

    D

    The WebSphere Commerce SecurityUpdate Command

    E

    The WebSphere Commerce Administration Console


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

  • 第11题:

    单选题
    Examine the following scenario:   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure?()
    A

     Restore the latest whole backup,perform complete recovery,and open the database normally 

    B

     Restore the latest whole backup,perform incomplete recovery,and open the database with the  RESETLOGS option.

    C

     Restore the latest backups control file,perform complete recovery,and open the database with the RESETLOGS option.

    D

     Restore the latest backup control file,perform incomplete recovery using backup control file,and open the database with the RESETLOG option.


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

  • 第12题:

    单选题
    A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database?()
    A

    Extractor, ID Resolver, XML Transformer, Mass Loader

    B

    ID Resolver, Text Transformer, Mass Loader

    C

    Text Transformer, XML Transformer, ID Resolver, Mass Loader

    D

    XML Transformer, ID Resolver, Mass Loader

    E

    XML Transformer, Mass Loader, ID Resolver


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

  • 第13题:

    Which WebSphere Commerce catalog management tool replaces symbols in an XML file with the appropriate numeric values for new or existing records in the WebSphere Commerce database?()

    • A、Data Checker
    • B、DTD Generator
    • C、ID Resolver
    • D、Mass Loader
    • E、XML Transformer

    正确答案:C

  • 第14题:

    In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()

    • A、 import the database from the last export
    • B、 restore all the members in the group from the last backup
    • C、 drop the lost member from the database and then add a new member to the group
    • D、 restore all the database files from the backup and then perform a complete recovery
    • E、 restore all the database files from the backup and then perform an incomplete recovery

    正确答案:C

  • 第15题:

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file?()

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file, just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第16题:

    Adam is working as a Database Administrator (DBA) for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup, he discovers that one of the disks crashed, resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details, he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure, what should Adam do to recover the USERS tablespace?()

    • A、 Restore the USERS01.dbf file from the backup, and open the database using the STARTUP command.
    • B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
    • C、 Restore the USERS01.dbf file from the backup, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
    • D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.

    正确答案:C

  • 第17题:

    单选题
    You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()
    A

     use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table

    B

     restore the entire database from the most recent backup and open it

    C

     recover the table by using the Flashback Table feature

    D

     perform point-in-time recovery to recover the table


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

  • 第18题:

    单选题
    WebSphere Commerce has been successfully installed and tested.  WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator.  What could be the cause of this problem?()
    A

    The WebSphere Commerce application server was not started

    B

    The web server was not started

    C

    SSL has not been configured on the web server

    D

    The appropriate listeners were not enabled in Configuration Manager

    E

    The database server was not started


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

  • 第19题:

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第20题:

    单选题
    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
    A

     Flash back all the tables in the data file, one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database, there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第21题:

    单选题
    Adam is working as a Database Administrator (DBA) for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup, he discovers that one of the disks crashed, resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details, he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure, what should Adam do to recover the USERS tablespace?()
    A

     Restore the USERS01.dbf file from the backup, and open the database using the STARTUP command.

    B

     Restore the USERS01.dbf file using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.

    C

     Restore the USERS01.dbf file from the backup, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.

    D

     Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.


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

  • 第22题:

    单选题
    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
    A

    flash back all the tables in the data file, one by one

    B

    restore the data file to a new location and perform a media recovery

    C

    flash back the database; there is no need to restore the data file

    D

    restore the data file from the most recent backup and flash back the database


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

  • 第23题:

    单选题
    In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
    A

     import the database from the last export

    B

     restore all the members in the group from the last backup

    C

     drop the lost member from the database and then add a new member to the group

    D

     restore all the database files from the backup and then perform a complete recovery

    E

     restore all the database files from the backup and then perform an incomplete recovery


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

  • 第24题:

    单选题
    In the event of a failure, what would be the MOST complete method for recovering the WebSphere Commerce database?()
    A

    Recreate the database from the staging server.

    B

    Restore a database backup.

    C

    Reload the data using Mass Loader.

    D

    Republish the store archive.

    E

    Republish from WebSphere Catalog Manager.


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