多选题You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）ASpecify the simple recovery model for DB1.BSpecify either the full or the bulk-logged recovery model for DB1.CPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.DPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.EBefore you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
多选题
You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）
A
Specify the simple recovery model for DB1.
B
Specify either the full or the bulk-logged recovery model for DB1.
C
Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.
D
Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.
E
Before you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
参考解析
解析：
暂无解析
相关考题：
You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform. a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.The server has two hard disks that are configured as shown in the Server Configuration exhibit.The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.What should you do?A．Shrink the empty data file on drive E. Place the new data file and the new log file on drive E.B．Shrink the empty data file on drive E. Backup and shrink the log file on drive C to 2 GB. Place the new data file on drive E and the new log file on drive C.C．Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB. Place the new data file on drive D and the new log file on drive E.D．Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB. Place the new data file and the new log file on drive C.
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit.The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.You want to optimize database performance. What should you do?A．Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive FB．Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive FC．Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive FD．Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)A. On drive C, create a transaction log.On drive D, create a data file in the PRIMARY filegroup.On drive E, create a data file in the SECONDARY filegroup.B. On each drive, create a transaction log.On each drive, create a data file in the PRIMARY filegroup.C. On drive D, create a transaction log.On drive E, create a data file in the PRIMARY filegroup.D. On the PRIMARY filegroup, create all tables and all indexes.E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.F. On the PRIMARY filegroup, create the Parts table and its indexes.On the SECONDARY filegroup, create all other tables and their indexes.
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
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（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
What is the architectural benefit of keeping WebLogic Server transaction log in the database?（）A、Oracle does not allow replicating files between data centers, so keeping transaction log in database allows for replication.B、Many transactions in WebLogic are database centric, so keeping log in database makes Two Phase Commit protocol possible.C、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.D、Transaction log in a file system is extremely slow so it cannot be efficiently replicated.
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. A new database should be deployed, and the capacity requirements listed below should be satisfied. There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports RAID levels 0, 1, 5, and 10. Since you are the technical support, you are required to maximize the write performance of the transaction log. In addition, you should protect the database and transaction log files, when a drive fails. The storage system should be designed. From the following four storage configuration, which one should you utilize?（）A、A single RAID 5 volume should be utilized. B、A RAID 1 volume and a RAID 5 volume should be utilized.C、A single RAID 10 volume should be utilized. D、A RAID 0 volume and a RAID 5 volume should be utilized.
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 which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal？（） A、You should recreate the indexes. B、You should compress the log file backups C、You should make the Dworks database use the Full recovery mode D、You should make the Dworks database use the Simple recovery mode.
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？（）A、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.B、Back up the current transaction log. Restore the database to the point just before the data loss.C、Restore the database from the existing backup files to a time just before the data loss.D、Restore the database to the point of the last full backup.
You work in a company which is named Wiikigo Corp. The company 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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. B、You should identify whether the SQL Server Agent is started on the primary server. C、You should identify whether the AdventureWorks database uses the Simple recovery model. D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
单选题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？（）ADecrease the amount of time between transaction log backups.BConfigure the database to use the simple recovery model.CConfigure the RECOVERY INTERVAL option to be a smaller value.DRun DBCC SHRINKFILE on the transaction log file.
单选题You work in a company which is named Wiikigo Corp. The company 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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （）AYou should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. BYou should identify whether the SQL Server Agent is started on the primary server. CYou should identify whether the AdventureWorks database uses the Simple recovery model. DYou should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A You must use automatic undo management in the database.B You must configure OMF in your database.C You must configure ASM for storing the datafiles.D You must multiplex the online redo log file.
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction.
多选题You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）ASpecify the simple recovery model for DB1.BSpecify either the full or the bulk-logged recovery model for DB1.CPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.DPerform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.EBefore you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY
单选题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（）AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction
单选题You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）AConfigure the database to use the bulk-logged recovery model.BEach night， rebuild only those indexes that require it.CDisable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.DIncrease the time between transaction log backups.
单选题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?（）A 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.B Back up the current transaction log. Restore the database to the point just before the data loss.C Restore the database from the existing backup files to a time just before the data loss.D Restore the database to the point of the last full backup.
单选题You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）ASchedule the full backups to run after the nightly index is rebuilt.BSchedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.CSchedule an additional transaction log backup to run after the nightly index is rebuilt.DSchedule a marker to be added to the transaction log before the nightly index is rebuilt.
单选题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 which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal？（）AYou should recreate the indexes. BYou should compress the log file backups CYou should make the Dworks database use the Full recovery mode DYou should make the Dworks database use the Simple recovery mode.
单选题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？（）APlace both the database and transaction log on two logical drives in one RAID-10 arrayBPlace both the database and transaction log on two logical drives in one RAID-1E arrayCPlace the database on a RAID-1E array and place the transaction log on a separate RAID-5 arrayDPlace the database on a RAID-5 array and place the transaction log on a separate RAID-1E array
单选题You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）AA single RAID 5 volumeBA single RAID 10 volumeCA RAID 0 volume and a RAID 5 volumeDA RAID 1 volume and a RAID 5 volume
单选题You network contains an Exchange Server 2010 Mailbox server.You install and configure a third-party antivirus application on the server.You discover that a mailbox database named DB1 does not mount.You attempt to mount the mailbox database and receive an error message starting that the file named E01.log cannot be found.You need to mount DB1.The solution must prevent the antivirus application from causing the same error. What should you do？（）ADisable the antivirus application.Restore E01.log from the most recent backup.Run the mount-database DB1 commandBDisable the antivirus application.Restore DB1 from the most recent backup.Run the mount-database DB1 commandCExclude the transaction log folder from the antivirus application scans.Restore E01.log from the antivirus quarentine.Run the mount-database DB1 commandDExclude the transaction log folder from the antivirus application scans.Restore DB1 from the most recent backup.Run the mount-database DB1 command
单选题You have an Exchange Server 2010 server that has a single mailbox database named DB1.You need to move the transaction log files of DB1.Which cmdlet should you run？（）AMove-DatabasePathBMove-MailboxCSet-ExchangeServerDSet-MailboxDatabase
单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A DBA_PENDING_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY
多选题You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in the database.