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 archive.
- E、Republish from WebSphere Catalog Manager.
相关考题：
Which components are installed on the middle tier in a WebSphere Commerce V 5.6 three-tier configuration （i.e. in a three-node topology）？（）A、WebSphere Commerce Server， WebSphere Application Server and Web server pluginB、WebSphere Application Server， Database Client and Web server pluginC、WebSphere Commerce Server， Database Server and WebSphere Application ServerD、WebSphere Commerce Server， WebSphere Application Server and Database ClientE、Web server， WebSphere Commerce Server and WebSphere Application Server
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 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 oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
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 ManagerB、The LDAP ServerC、The WebSphere Application Server Administrative ConsoleD、The WebSphere Commerce SecurityUpdate CommandE、The WebSphere Commerce Administration Console
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.
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 startedB、The web server was not startedC、SSL has not been configured on the web serverD、The appropriate listeners were not enabled in Configuration ManagerE、The database server was not started
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.
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 CheckerB、DTD GeneratorC、ID ResolverD、Mass LoaderE、XML Transformer
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 LoaderB、ID Resolver， Text Transformer， Mass LoaderC、Text Transformer， XML Transformer， ID Resolver， Mass LoaderD、XML Transformer， ID Resolver， Mass LoaderE、XML Transformer， Mass Loader， ID Resolver
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 exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery
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 technologyB、restore the data files from backup and perform a complete recoveryC、restore only the corrupted data file and perform tablespace recoveryD、restore the data files from backup and perform cancel-based recoveryE、restore the entire database from the most recent backup and start the instance and open the database
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 databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
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.
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.
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.
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 tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
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.
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA、 b， a， c， d， eB、 a， c， b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 e， a， b， d， c
多选题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？（）AThe database has a subset of the tables in the production server database.BThe database has a copy of selected data from the production databaseCThe database logs changes for later propagation.DThe database is accessed as read-only to prevent data corruption.EThe database includes all user and order data for offline processing.
单选题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？（）Arecover using Oracle Flashback Database technologyBrestore the data files from backup and perform a complete recoveryCrestore only the corrupted data file and perform tablespace recoveryDrestore the data files from backup and perform cancelbased recoveryErestore the entire database from the most recent backup and start the instance and open the database
单选题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.
单选题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？（）AThe Database Update Tool found in Configuration ManagerBThe LDAP ServerCThe WebSphere Application Server Administrative ConsoleDThe WebSphere Commerce SecurityUpdate CommandEThe WebSphere Commerce Administration Console
单选题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？（）Aflash back all the tables in the data file， one by oneBrestore the data file to a new location and perform a media recoveryCflash back the database; there is no need to restore the data fileDrestore the data file from the most recent backup and flash back the database
单选题Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA b， a， c， d， eB a， c， b， d， fC c， a， b， d， eD c， a， b， d， fE e， a， b， d， c
单选题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 exportB restore all the members in the group from the last backupC drop the lost member from the database and then add a new member to the groupD restore all the database files from the backup and then perform a complete recoveryE restore all the database files from the backup and then perform an incomplete recovery
单选题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？（）AExtractor， ID Resolver， XML Transformer， Mass LoaderBID Resolver， Text Transformer， Mass LoaderCText Transformer， XML Transformer， ID Resolver， Mass LoaderDXML Transformer， ID Resolver， Mass LoaderEXML Transformer， Mass Loader， ID Resolver
单选题In the event of a failure， what would be the MOST complete method for recovering the WebSphere Commerce database？（）ARecreate the database from the staging server.BRestore a database backup.CReload the data using Mass Loader.DRepublish the store archive.ERepublish from WebSphere Catalog Manager.