Recreate the database from the staging server.
Restore a database backup.
Reload the data using Mass Loader.
Republish the store archive.
Republish from WebSphere Catalog Manager.
第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?()
第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?()
第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?()
第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?()
第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?()
第6题:
drop and re-create the WebSphere Commerce Payments database.
stop and start the Payment Engine.
configure WebSphere Commerce Server communication with WebSphere Commerce Payments Server.
specify what type of Database software will be used for the WebSphere Commerce Payments database.
第7题:
The database has a subset of the tables in the production server database.
The database has a copy of selected data from the production database
The database logs changes for later propagation.
The database is accessed as read-only to prevent data corruption.
The database includes all user and order data for offline processing.
第8题:
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.
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.
Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data.
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.
第9题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online
第10题:
The Database Update Tool found in Configuration Manager
The LDAP Server
The WebSphere Application Server Administrative Console
The WebSphere Commerce SecurityUpdate Command
The WebSphere Commerce Administration Console
第11题:
Restore the latest whole backup,perform complete recovery,and open the database normally
Restore the latest whole backup,perform incomplete recovery,and open the database with the RESETLOGS option.
Restore the latest backups control file,perform complete recovery,and open the database with the RESETLOGS option.
Restore the latest backup control file,perform incomplete recovery using backup control file,and open the database with the RESETLOG option.
第12题:
Extractor, ID Resolver, XML Transformer, Mass Loader
ID Resolver, Text Transformer, Mass Loader
Text Transformer, XML Transformer, ID Resolver, Mass Loader
XML Transformer, ID Resolver, Mass Loader
XML Transformer, Mass Loader, ID Resolver
第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?()
第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?()
第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?()
第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?()
第17题:
use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
restore the entire database from the most recent backup and open it
recover the table by using the Flashback Table feature
perform point-in-time recovery to recover the table
第18题:
The WebSphere Commerce application server was not started
The web server was not started
SSL has not been configured on the web server
The appropriate listeners were not enabled in Configuration Manager
The database server was not started
第19题:
recover using Oracle Flashback Database technology
restore the data files from backup and perform a complete recovery
restore only the corrupted data file and perform tablespace recovery
restore the data files from backup and perform cancelbased recovery
restore the entire database from the most recent backup and start the instance and open the database
第20题:
Flash back all the tables in the data file, one by one.
Restore the data file to a new location and perform a media recovery.
Flash back the database, there is no need to restore the data file.
Restore the data file from the most recent backup and flash the database.
第21题:
Restore the USERS01.dbf file from the backup, and open the database using the STARTUP command.
Restore the USERS01.dbf file using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
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.
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.
第22题:
flash back all the tables in the data file, one by one
restore the data file to a new location and perform a media recovery
flash back the database; there is no need to restore the data file
restore the data file from the most recent backup and flash back the database
第23题:
import the database from the last export
restore all the members in the group from the last backup
drop the lost member from the database and then add a new member to the group
restore all the database files from the backup and then perform a complete recovery
restore all the database files from the backup and then perform an incomplete recovery
第24题:
Recreate the database from the staging server.
Restore a database backup.
Reload the data using Mass Loader.
Republish the store archive.
Republish from WebSphere Catalog Manager.