D365 F&O Technical › Module 14: Database Manipulation › Question #9390
MCQ Single Best Answer Easy

QYou are to complete the code needed to insert records. You need to ensure that a transaction completes successfully so that records are inserted into the database. Which will best complete this statement? 

{
ttsbegin;
fmVehicle.dbVehicleID = ‘123456789’;
fmVehicle.insert();
 _________________ 
}

ID: #9390 Module 14: Database Manipulation 188 views
Question Info
#9390Q ID
EasyDifficulty
Module 14: Database ManipulationTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A ttsabort; ✔ ✖
  • B insert; ✔ ✖
  • C escape; ✔ ✖
  • D ttscommit; ✔ ✖
Correct Answer: Option D

Explanation

Justification:

  1. ttsAbort will prevent the data from being written to the table and roll the transaction back to the state before the ttsBegin was called.
  2. The insert method is called on table to insert data, but it does not control the transaction tracking system.
  3. This is not a valid command used for transaction integrity.
  4. This is correct. The ttsCommit command ensures there were no errors during the insertion process. After the ttsCommit is called, the data will be written to the given table.

 

Related Lesson: Data Insert

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

You are to complete the code needed to update records. You need to assign the updated value for the vehicle mo You are to complete the code needed to update records. You would like find the equivalent value. Which will be You are writing a query to retrieve the customers that are not associated with a sales order. What join betwee You are to complete the code needed to read records. Which will best complete this statement? <pre class = You need to update the unit price of multiple sales orders. What method would be best to use? You have tables named salesTable and salesLine. The salesTable contains the following data:<p> SalesId R The Update command modifies existing data in a table with the contents of a table buffer. TRUE OR FALSE? You need to find the equivalent value in the second table. Which will best complete this statement? <pre cl What are the three keywords associated with the Transaction Tracking System? You are to complete the code needed to insert a given record. Which will best complete this statement? <pre