Which two statements complete a transaction? ()
A single transaction can be scanned in parallel by:()
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table,you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
By using the transaction identifier provided by () for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the 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?()
Which two statements complete a transaction?()
The importance of a contract in an international sales transaction cannot be underestimated. Often it is the only document between the parties to which they may refer for clarification of mutual responsibilities, and resolution of disputes in the event of disagreement. Such a contract may well survive the relationship it defines. So the exporter should avoid viewing the contract merely as a document that initiates transaction and subsequently is filed and forgotten. Contracts must be drafted with an awareness of the background of the law in which the transaction takes place, with a clear conception of the various services it may be called upon to render. It is best to obtain legal advice as to the best set of contractual terms appropriate to the product and type of business.
In WebLogic 10.3.6 and 12c, transaction logs can optionally write to a JDBC store instead of a file store on the file system. Identify the three benefits as a result of this capability.()
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()