Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()

  • A、point-in-time recovery
  • B、execute the ROLLBACK command with transaction number
  • C、flashback the database to before the transaction was committed
  • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

相关考题:

You are writing a method that accepts a string parameter named message.Your method must break the message parameter into individual lines of text and pass each line to a second method named Process.Which code segment should you use?()A.B.C.D.

You are writing a method to compress an array of bytes.The array is passed to the method in a parameter named document.You need to compress the incoming array of bytes and return the result as an array of bytes.Which code segment should you use?()A.B.C.D.

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?() A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

Which command (without options) would you use to display how much space is available on all mounted partitions?()

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task?()A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?()A、B、ACCEPTC、PROMPTD、

You have a login.ascx control and to display it in a view which method u would use()A、http.displayB、http.partialC、http.loadD、http.get

Which event would you use to run a method immediately after serialization occurs?()A、 OnSerializingB、 OnDeserializingC、 OnSerializedD、 OnDeserialized

You are developing a Windows Communication Foundation (WCF) service. You write a method named Submit that accepts messages of the type System.ServiceModel.Channels.Message. You need to process the body of the incoming messages multiple times in the method. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)()A、Use the GetBody method of the Message class to read the content of the messages.B、Use the CreateBufferedCopy method of the Message class to load the messages into memory.C、Use the WriteBodyContents method of the BodyWriter class to make a copy of the messages.D、Use the CreateMessage method of the MessageBuffer class to make a copy of the messages.

You are designing a strategy to perform inplace upgrade of domain controller in Boston and San Diego. Which method should you use?()A、adprepB、sysprepC、Answer FileD、Remote Installtion Services (RIS)

单选题You have a login.ascx control and to display it in a view which method u would use()Ahttp.displayBhttp.partialChttp.loadDhttp.get

单选题You are developing a method to decrypt data that was encrypted with the Triple DES Algorithm. The method accepts the following parameters:  The byte array to be decrypted, which is named cipherMessage  The key, which is named key   An initialization vector, which is named iv  You need to decrypt the message by using the TripleDES class and place the result in a string.  Which code segment should you use?()A AB BC CD D

单选题Which protocols would you want to use for secure VPN ?()AEAPBChapCMs-ChapDPPTPEPAPFSPAP

单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import

单选题You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()AOnly hostBOnly localCEither host or localDBoth host and local

单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?()ABACCEPTCPROMPTD

单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A point-in-time recoveryB execute the ROLLBACK command with transaction numberC flashback the database to before the transaction was committedD determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

单选题You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()A Data Pump Export and ImportB conventional export and importC the CONVERT command of RMAND the BACKUP AS COPY. command of RMAN

单选题You work as an application developer at Certkiller .com. You are developing an application that makes use of a Queue class object named MyQueue. This Queue class object will be used to store messages sent by the user during application run time.You would like to access the message at the beginning of the queue, prior to processing the user messages, without removing it. What should you do?()A Use the Enqueue method of the MyQueue object.B Use the Contains method of the MyQueue object.C Use the Dequeue method of the MyQueue object.D Use the Peek method of the MyQueue object.

单选题Your network has a single domain with 1,000 client computers that run Windows Vista. You are planning a deployment of Windows 7. Your company has multiple departments.   Only the sales department will use the existing target computers to run Windows 7.   You have the following requirements:Migrate the user state for each user.  Preserve the file system and existing applications for only the sales department computers.    You need to recommend the deployment method that is appropriate for the environment.    Which combination of deployment scenarios should you recommend?()A Use the Refresh Computer method for the sales department computers. Use the New Computer method for all other computers.B Use the Refresh Computer method for the sales department computers. Use the Replace Computer method for all other computers.C Use the Upgrade Computer method for the sales department computers. Use the Refresh Computer method for all other computers.D Use the Upgrade Computer method for the sales department computers. Use the Replace Computer method for all other computers.

单选题Which event would you use to run a method immediately after serialization occurs?()A OnSerializingB OnDeserializingC OnSerializedD OnDeserialized

单选题You are designing a strategy to enable the ATC application to successfully resolve computer names. Which name resolution method should you use?()ADNSBWINSCHosts fileDLmhosts file