网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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()
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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()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.” 相关考题
考题 She is working very hard to ______ the lost time at school. A.make forB.make up forC.make upD.make ou

考题 _________, doesn' t it?- Yes, it does.1 like the color and style. A.It is going to rain pretty soonB.Y ou look very beautifulC.The red dress fits me very much

考题 开始事务,提交事务,回滚事务的英语单词分别是:A.begin transaction , rollback transaction , commit transactionB.commit transaction , rollback transaction , begin transactionC.rollback transaction , begin transaction , commit transactionD.begin transaction , commit transaction , rollback transaction

考题 People of ancient Egypt and Europeans of the Middle Ages ______.A. both worshipped black catsB. both feared black catsC. thought black cats could bring good luckD. felt very different about black cats

考题 The technological advances made it possible for the middle classes to enjoy what had once been()only to the very rich.A. manageableB. measurableC. affordable

考题 The two industries embody both import and export () a single transaction. The purpose of importation is to create exportation.A、inB、atC、forD、of

考题 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.

考题 When installing a server in a rack, which of the following locations describes where in the rack a server should be installed?()A、On the very bottom U of the rack, with the UPS above the serverB、In the middle of the rack to help balance the rackC、Closest to the bottom of the rack, above heavier equipmentD、On the very top U of the rack, with the UPS directly below it

考题 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

考题 By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) A list of changes made along with the transaction identifier of each change.  b) The necessary SQL statements to undo the erroneous changes.  Which option would you choose?()A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.

考题 You need to design an audit strategy for Southbridge Video. Your solution must meet business requirements.What should you do?()A、Create a new security template that enables the Audit account logon events policy for successful and failed attempts. Create a new GPO, and link it to the domain. Import the new security template into the new GPOB、Create a new security template that enables the Audit account logon events policy for successful and failed attempts. Create a new GPO, and link it to the Domain Controllers OU. Import the new security template into the new GPOC、Create a new security template that enables the Audit logon events policy for successful and failed attempts. Create a new GPO, and link it to the Domain Controllers OU. Import the new security template into the new GPOD、Create a new security template that enables the Audit logon events policy for successful and failed attempts. Create a new GPO, and link it to the domain. Import the new security template into the new GPO

考题 You are the administrator of your company’s network. You use Security Templates to configure a Security Policy on the Windows 2000 Professional Computers in the Sales organizational unit (OU). You notice that the Computers in the Sales OU are not downloading the Security Policy settings. On each computer, the Security Policy appears in the Local Computer Policy, but is not listed as the effective policy. You want all computers in the Sales OU to have the Security Policy listed as the effective policy. How should you accomplish this task? ()A、Use Security Templates to correct the setting and export the security file.B、Use Security Configuration and Analysis to import the security setting. Then create a Group policy object (GPO) for the Sales QU.C、Use Secedit /RefreshPolicy Machine_Policy command.D、Use the Basicwk.inf security file settings, save the security file, and then import the fileto theComputers.

考题 You are designing the top-level organizational unit (OU) structure to meet the business and technical requirements. Your design must accommodate the anticipated growth of the company.  Which top-level OU structure should you use?()A、Paris OU, Sydney OU, Los Angeles OU, Lisbon-Barcelona OU  B、IT Administration OU, All CohoVineyard Departments OU, All CohoVineyard Offices OUC、Sales OU, Purchasing OU, Marketing OU, Accounting OU, Distribution OU, Human Resources OUD、CohoVineyard Users OU, CohoVineyard Computers OU, CohoVineyard Servers OU, CohoVineyard Applications OU

考题 单选题Daniel Defoe describes _____ as a typical English Middle-class man of the eighteenth century, the very prototype of the empire builder or the pioneer colonist.A Tom JonesB GulliverC Moll FlandersD Robinson Crusoe

考题 单选题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?()A Decrease the amount of time between transaction log backups.B Configure the database to use the simple recovery model.C Configure the RECOVERY INTERVAL option to be a smaller value.D Run DBCC SHRINKFILE on the transaction log file.

考题 单选题When installing a server in a rack, which of the following locations describes where in the rack a server should be installed?()A On the very bottom U of the rack, with the UPS above the serverB In the middle of the rack to help balance the rackC Closest to the bottom of the rack, above heavier equipmentD On the very top U of the rack, with the UPS directly below it

考题 单选题You need to design a method to deploy security configuration settings to servers. What should you do?()A Run the Resultant Set of Policy wizard with a Windows Management Instrumentation (WMI) filter on each department’s Server OUB Log on to each server and use local policy to configure and manage the security settingsC Create a customer security template. Log on to a domain controller and run the seceditcommand to import the security templateD Create a customer security template. Create a GPO and import the security template. Link the GPO to each department’s Server OU

考题 单选题—Middle school students don’t know much about shopping online, ______ they?— ______. It’s very popular with teenagers.A do;NoB do; YesC don’t; NO

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

考题 多选题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 the administrator of your company's network. You want to configure a Security Policy for the Windows 2000 Professional Computers that are in the sales department.   On one of the computers, you use Security Templates to configure the Security Policy based on the desired security settings. You then export those settings to an .inf file that will be used on all of the Computers in the sales department. You want to configure each Computer to have a customized Security Policy. What steps should you follow in order to achieve your goal?()A Use Secedit.exe to import the security settings from the .inf file to the computers in the sales department.B Use a text editor to change the default security settings to the desired security settings. Then export those settings to the Computers in the sales department.C Create an organizational unit (OU) named Sales. Add the users in the sales department to the Sales OU. Then apply the security template to the users in the Sales OU.D Create an organizational unit (OU) named Sales. Add the computers in the sales department to the Sales OU. Then apply the security template to computers in the Sales OU.

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

考题 单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) a list of changes made along with the transaction identifier of each change  b) the necessary SQL statements to undo the erroneous changes  Which option would you choose?()A RMAN onlyB Flashback Table onlyC Flashback Versions Query onlyD Flashback Database and Flashback Transaction QueryE Flashback Versions Query and 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.

考题 单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) A list of changes made along with the transaction identifier of each change.  b) The necessary SQL statements to undo the erroneous changes.  Which option would you choose?()A  RMAN only.B  Flashback Table only.C  Flashback Version Query only.D  Flashback Database and Flashback Transaction Query.E  Flashback Version Query and Flashback Transaction Query.

考题 单选题According to the author, the economy of East Asian countries grew very fast because of the following measures EXCEPT ______.A encouraging exportB opening up to foreign investmentsC limiting international financial flowsD controlling import