Oracle does not allow replicating files between data centers, so keeping transaction log in database allows for replication.
Many transactions in WebLogic are database centric, so keeping log in database makes Two Phase Commit protocol possible.
It obviates the need to keep in sync two replication technologies (file and database) between data centers. The single replication technology is used for frequently changing data.
Transaction log in a file system is extremely slow so it cannot be efficiently replicated.
第1题:
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation()
第2题:
Which new key architectural element introduced in WebLogic Server l2c should you take advantage of when designing Disaster Recovery Centers with active - passive mode?()
第3题:
What is the architectural benefit of keeping WebLogic Server transaction log in the database?()
第4题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. VIP customer data of the company are stored in DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data, that is to say, even if the backup media is lost, you must guarantee that data files, log files and subsequent backups and so on are as safe as possible. So what action should you perform to achieve this goal?()
第5题:
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?()
第6题:
A customer needs to install a database on a server. Which of the following statements describes how to modify the RAID configuration for optimal performance?()
第7题:
The online redo log files and archived redo log files are required to accomplish the recovery.
The uncommitted transaction will be committed at the next startup of the database instance.
The uncommitted transaction is rolled back automatically at the next opening of the database.
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
第8题:
Oracle Weblogic Server; Oracle Database
Oracle Weblogic Server clusters; Oracle Database
Oracle Weblogic Server clusters; Oracle Database RAC
Oracle OC4J; Oracle Database RAC
第9题:
Oracle does not allow replicating files between data centers, so keeping transaction log in database allows for replication.
Many transactions in WebLogic are database centric, so keeping log in database makes Two Phase Commit protocol possible.
It obviates the need to keep in sync two replication technologies (file and database) between data centers. The single replication technology is used for frequently changing data.
Transaction log in a file system is extremely slow so it cannot be efficiently replicated.
第10题:
Oracle WebLogic Server; Oracle Database
Oracle WebLogic Server clusters; Oracle Database
Oracle WebLogic Server clusters; Oracle Database RAC
Oracle OC4J; Oracle Database RAC
Oracle WebLogic Server; Oracle OC4J
第11题:
For both the CustomerDB database and the master database, enable Transparent Database Encryption
You should use the built-in encryption functions to encrypt the sensitive data at the cell Ievel
You should make the CustomerDB database accessible only through stored procedures and functions.
For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
第12题:
The online redo log files and archived redo log files are required to accomplish the recovery.
The uncommitted transaction will be committed at the next startup of the database instance.
The uncommitted transaction is rolled back automatically at the next opening of the database.
The DBA has to perform the recovery on the database to recover the uncommitted transaction
第13题:
Integration between () multidata sources and () is defined as the Grid Link for RAC.
第14题:
Which two statements about the background process of the database writer are true()
第15题:
A customer has a critical, performance-sensitive web application that connects to a multimode Oracle RAC database. Which feature of WebLogic can provide signification benefit?()
第16题:
You need to resolve the double counting of transactions issue in the existing reports. What should you do?()
第17题:
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do?()
第18题:
Place both the database and transaction log on two logical drives in one RAID-10 array
Place both the database and transaction log on two logical drives in one RAID-1E array
Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 array
Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array
第19题:
Decrease the amount of time between transaction log backups.
Configure the database to use the simple recovery model.
Configure the RECOVERY INTERVAL option to be a smaller value.
Run DBCC SHRINKFILE on the transaction log file.
第20题:
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
第21题:
For both the CustomerDB database and the master database, enable Transparent Database Encryption.
You should use the built-in encryption functions to encrypt the sensitive data at the cell level.
You should make the CustomerDB database accessible only through stored procedures and functions.
For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
第22题:
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
第23题:
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.
第24题:
Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
Apply a Conditional Split transformation in the Transaction data in the SSIS package.
Delete the AccountHolder table in the WoodgroveDW database.
Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.