Store Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.
Use file based Transaction Logs and JMS stores and implement a separate replication solution for files in addition to database in case database replication fails.
Implement Oracle RAC at each site to provide a highly available solution within each datacenter.
Configure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.
Configure Automatic Service Migration for JMS high availability within a datacenter.
第1题:
A customer has the need to implement a tape backup solution to backup a 500GB database on a daily basis. Which of the following factors is the most important consideration in the design of a backup and restore solution?()
第2题:
A customer would like to implement an IBM System Storage DS8000 solution. A Capacity Magic study has determined that 500 drives of 450 GB are required to meet the customer’s capacity requirements. Limited space is available for additional systems in the data center. Which solution best meets the customer’s requirements()
第3题:
A customer needs to implement a Highly Available solution for JMS that has a primary data center and a backup. Which three steps would you perform when designing your solution?()
第4题:
In which case would you use the Flashback Database feature to perform a recovery?()
第5题:
In the absence of shared storage between cluster nodes, which two actions can you take to configure a High Availability architecture?()
第6题:
Identify two situations in which you can use Data Recovery Advisor for recovery.()
第7题:
You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
第8题:
Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)
第9题:
The user has dropped an important table that needs to be recovered.
The database files are corrupted when the database is open.
You are not able to start up the database instance because the required database files are missing.
The archived log files are missing for which backup is not available.
第10题:
to recover a dropped tablespace
to recover data from a truncated table
to recover a data file that has been shrunk
to recover a database to the state that existed before the RESETLOGS operation
第11题:
Update the client application that is creating the JMS messages to use Unit of Work.
Configure a WebLogic Cluster for Distributed JMS.
Update the client application that is creating the JMS messages to use Unit of Order.
Enable XA Transactions on the JMS Connection Factory used by the client application.
Enable Load Balancing on the JMS connection factory used by the client application.
第12题:
heap tables
object tables
partitioned tables
index-organized tables (IOTs)
第13题:
When designing a single tier AIX database solution for a customer, what other technical specialist would be most instrumental in putting together a total solution and why?()
第14题:
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?()
第15题:
A customer is developing a custom application that involves a multistep provisioning process for a new account. There is a custom Java client application that is generating multiple JMS messages as part of the process and sending them to the WebLogic tier where they are processed. Which three steps must you take to implement the solution to allow for scalability and parallel processing of multiple simultaneous provisioning requests while ensuring messages for an individual process are not delivered out of order?()
第16题:
You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
第17题:
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?()
第18题:
You work as a database administrator for Supportcenter.cn. 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?()
第19题:
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?()
第20题:
perform point-in-time recovery
perform a Flashback Table operation to restore the table to the state it was in two days ago
perform a Flashback Database operation to restore the database to the state it was in two days ago
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
第21题:
Restore the data file for the SYSTEM tablespace then open the database.
Restore all redo logs form last night's backup, then restart the database.
Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
第22题:
Store Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.
Use file based Transaction Logs and JMS stores and implement a separate replication solution for files in addition to database in case database replication fails.
Implement Oracle RAC at each site to provide a highly available solution within each datacenter.
Configure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.
Configure Automatic Service Migration for JMS high availability within a datacenter.
第23题:
The user has dropped an important table that needs to be recovered.
The database files are corrupted when the database is open.
You are not able to start up the database instance because the required database files are missing.
The archived log files are missing for which backup is not available.
第24题:
Move domain logs to a highly available database.
Move server logs to a highly available database.
Move transaction logs to a highly available database.
Move JMS persistent stores to a highly available database.
Move error logs to a highly available database.