多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()AOn startup, SMON coordinates instance recovery.BOn startup, CKPT coordinates instance recovery.COn startup, use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup, perform media recovery and then instance recovery.FOn startup, all the files will be synchronized and you get both committed and uncommitted data.

多选题
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()
A

On startup, SMON coordinates instance recovery.

B

On startup, CKPT coordinates instance recovery.

C

On startup, use RMAN to perform instance recovery.

D

Uncommitted changes will be rolled back after the database is opened.

E

On startup, perform media recovery and then instance recovery.

F

On startup, all the files will be synchronized and you get both committed and uncommitted data.


参考解析

解析: 暂无解析

相关考题:

You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A.Select the commit on successful completion check box of the DTS package.B.Select the commit transaction on successful completion of this step check box of the customers transform. data task.C.Select the commit transaction on successful completion of this step check box of the sales transform. data task.D.Select the commit transaction on successful completion of this step check box of both transform. data tasks.

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.

Which of the following data network would you implement if you wanted a wireless network that had a relatively high data rate, but was limited to very short distances?()A、Broadband personal comm. Service (PCS)B、Broadband circuitC、InfraredD、Spread spectrumE、Cable

You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager (RMAN) to roll backF、Uses the System Monitor (SMON) background process to perform instance recovery

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()A、On startup, SMON coordinates instance recovery.B、On startup, CKPT coordinates instance recovery.C、On startup, use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup, perform media recovery and then instance recovery.F、On startup, all the files will be synchronized and you get both committed and uncommitted data.

You are designing a Windows Azure application that will use Windows Azure Table storage.  You need to recommend an approach for minimizing storage costs.  What should you recommend? ()A、 Use Entity Group Transactions.B、 Use multiple partitions to store data.C、 Use a transaction scope to groupall storage operations.D、 Use Microsoft Distributed Transaction Coordinator (MSDTC).

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

One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()A、uses undo data for roll forwardB、uses Flashback Log for recoveryC、uses online redo logs to roll backD、uses undo data to roll back the transactionE、uses Recovery Manager (RMAN) to roll backF、uses the System Monitor (SMON) background process to perform instance recovery

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?()A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

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?()A、 perform point-in-time recoveryB、 perform a Flashback Table operation to restore the table to the state it was in two days agoC、 perform a Flashback Database operation to restore the database to the state it was in two days agoD、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

You need to resolve the double counting of transactions issue in the existing reports. What should you do?()A、Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.B、Apply a Conditional Split transformation in the Transaction data in the SSIS package.C、Delete the AccountHolder table in the WoodgroveDW database.D、Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.

You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements:   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend?()A、 Use Windows Azure Queues.B、 Use a single SQL Azure database.C、 Use a single Windows Azure Drive.D、 Use Windows Azure Table storage.

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 as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()AUses undo data for roll forwardBUses Flashback Log for recoveryCUses online redo logs to roll backDUses undo data to roll back the transactionEUses Recovery Manager (RMAN) to roll backFUses the System Monitor (SMON) background process to perform instance recovery

单选题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.

单选题Which of the following data network would you implement if you wanted a wireless network that had a relatively high data rate, but was limited to very short distances?()ABroadband personal comm. Service (PCS)BBroadband circuitCInfraredDSpread spectrumECable

单选题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.

单选题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?()Aheap tablesBobject tablesCpartitioned tablesDindex­organized tables (IOTs)

单选题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 have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage,which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables.  Which action would you take to delay the referential integrity checking until the end of thetransaction()A Set the constraint to deferred before starting the transaction.B Alter the constraint to NOVALIDATE state before starting the transaction.C Enable the resumable mode for the session before starting the transaction.D Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

单选题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 in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()AOn startup, SMON coordinates instance recovery.BOn startup, CKPT coordinates instance recovery.COn startup, use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup, perform media recovery and then instance recovery.FOn startup, all the files will be synchronized and you get both committed and uncommitted data.

单选题One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()Auses undo data for roll forwardBuses Flashback Log for recoveryCuses online redo logs to roll backDuses undo data to roll back the transactionEuses Recovery Manager (RMAN) to roll backFuses the System Monitor (SMON) background process to perform instance recovery

单选题You are designing a Windows Azure application that will use Windows Azure Table storage.  You need to recommend an approach for minimizing storage costs.  What should you recommend? ()A Use Entity Group Transactions.B Use multiple partitions to store data.C Use a transaction scope to groupall storage operations.D Use Microsoft Distributed Transaction Coordinator (MSDTC).

单选题You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements:   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend?()A Use Windows Azure Queues.B Use a single SQL Azure database.C Use a single Windows Azure Drive.D Use Windows Azure Table storage.

单选题You are designing a Windows Azure application that will store data in two SQL Azure databases. The application will insert data in both databases as part of a single logical operation.   You need to recommend an approach for maintaining data consistency across the databases.  What should you recommend?()A Execute database calls on parallel threads.B Wrap the database calls in a single transaction scope.C Use Microsoft Distributed Transaction Coordinator (MSDTC).D Handle errors resulting from the database calls by using compensatory logic.

多选题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.