Module 14: Database Manipulation - Quiz

Q: You are to complete the code needed to read records. Which will best complete this statement?


While _________  fmVehicleMaint join fmVehicle

A. select forUpdate
B. select
C. order by
D. select into

Correct Option: B
Remarks:

Explanation:

Justification:

The select forUpdate command indicates that the table buffer will alter the contents of the table and is typically used for inserting or deleting records, not simply reading them.
The “select” keyword is used to retrieve and read records.
Order by is not used to read records, but rather to order the resulting records that are returned in the select statement.
Select into is not used in X++ to read or retrieve records.

Related Lesson: Reading Records

Q: You 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();
 _________________ 
}

A. ttsabort;
B. insert;
C. escape;
D. ttscommit;

Correct Option: D
Remarks:

Explanation:

Justification:

ttsAbort will prevent the data from being written to the table and roll the transaction back to the state before the ttsBegin was called.
The insert method is called on table to insert data, but it does not control the transaction tracking system.
This is not a valid command used for transaction integrity.
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

Q: You are to complete the code needed to update records. Which will best complete this statement?


while select _______  fmVehicle

A. read
B. forupdate
C. lock
D. firstOnly

Correct Option: B
Remarks:

Explanation:

Justification:

Read is not a valid keyword to be used in a select statement or to update records.
The forUpdate keyword is used in a select statement to indicate the table is being selected for the purpose of updating or changing data.
Lock is not a valid keyword to be used in a select statement or to update records.
The firstOnly keyword is used to retrieve only the first record from the table.

Related Lesson: Data Updates

Q: You are to complete the code needed to update records. You would like find the equivalent value. Which will best complete this statement?


where fmVehicle.dbVehicleID ________ 1

A. ==
B. =
C. +=
D. !=

Correct Option: A
Remarks:

Explanation:

Justification:

The “==” is used as a relational operator between the field and the value of 1 in this example. This returns “true” when the two expressions are equal.
The “=” operator is an assignment operator. Therefore, it is used when assigning values to variables. It is not a relational operator.
The “+=” is an assignment operator that increments the value of the variable on the left by the value of the expression on the right.
The “!=” operator is a relational operator returns “true” if the expressions are NOT equal.

Related Lesson: Data Updates

Q: You are to complete the code needed to update records. You need to assign the updated value for the vehicle model before updating. Which will best complete this statement?


{
fmVehicle.dbModel _______ "Big Truck";
 fmVehicle.update();
 }

A. ==
B. =
C. +=
D. !=

Correct Option: B
Remarks:

Explanation:

Justification:

The “==” is used as a relational operator. This returns “true” when the two expressions are equal, it does not assign any values.
The “=” is the correct operator to use to assign the value of the dbModel field to the value “Big Truck” in this example.
The “+=” is an assignment operator that increments the value of the variable on the left by the value of the expression on the right. It does not assign values.
The “!=” operator is a relational operator returns “true” if two expressions are NOT equal. It does assign values.

Related Lesson: Data Updates

Q: You are to complete the code needed to delete records. Which will best complete this statement?


     {
            fmVehicle.________();
        }

A. drop
B. kill
C. deletefrom
D. delete

Correct Option: D
Remarks:

Explanation:

Justification:

Drop is not a valid method call on the given table and does not delete records.
Kill is not a valid method call on the given table and does not delete records.
Deletefrom is not a valid method call on the given table and will not delete records.
The delete method on the table is called when records are to be deleted.

Related Lesson: Data Deletion

Q: You have tables named salesTable and salesLine. The salesTable contains the following data:

SalesId RecId

SO0001 1234567

SO0002 1234568

SO0003 1234569

The salesLine table contains the following information:

SalesId RecId

SO0003 2234567

SO0002 2234568

SO0003 2234569

You need to identify the output of the X++ statement:


SalesTable	salesTable;
 SalesLine	salesLine;


while select salesTable
       order by salesLine.Recid desc
	  join salesLine
	  where salesLine.salesId == salesTable.salesid
           
	{
		 info(strfmt("%1",salesTable.salesId));
	}

What should you identify

A. SO0001 SO0002 SO0003
B. SO0002 SO0003 SO0003
C. SO0003 SO0002 SO0003
D. SO0002 SO0002 SO0003

Correct Option: C
Remarks:

Explanation:

Justification:

a) The code performs a join between the two tables on SalesID, which means only related records, or records that exists in both locations for that field will be returned. Therefore, we will not see SO0001 in the output.
b) The three sales order IDs are correct, but they are in the wrong order because the order of the selects is based on the record ID on the sales line descending - resulting in SO0003 (highest recID on the lines), then SO0002, then finally SO0003 again (lowest recID on the lines).
c) The code performs a join between the two tables on SalesID, which means only related records, or records that exists in both locations for that field will be returned. Therefore, we will not see SO0001 in the output. We then specify to order the salesLine table in descending order based on the RecID field. The while loop will print the SalesID line by line in that order, which would yield the result: SO0003 SO0002 SO0003.
d) The code performs a join between the two tables on SalesID, which means only related records, or records that exists in both locations for that field will be returned. There is only one sales line with SalesID SO0002.

Related Lesson: Data Retrieval

Q: 13. TRUE or FALSE. When performing a data insert, the insert() command inserts the contents of a table buffer.

A. True
B. False

Correct Option: B
Remarks:

Explanation:

Justification:

True: This statement is true. The insert command is used on a table buffer.

Related Lesson: Data Insert

Q: The Update command modifies existing data in a table with the contents of a table buffer. TRUE OR FALSE?

A. True
B. False

Correct Option: A
Remarks:

Explanation:

Justification:

True: This statement is true. The update() method is called on a table to update its contents using a table buffer. The data is updated by assigning new values to the fields.

Related Lesson: Data Updates

Q: You need to run a process in parallel. There are around 1,000 work items that would need to run with a bundle size of 100. You know that the run time for each work item will vary. What approach should you take to run this process?

A. Individual task modeling
B. Batch bundling
C. Top picking

Correct Option: C
Remarks:

Explanation:

A. Incorrect: The individual task modeling does not handle multiple records well.
B. Incorrect: Because the run time varies between work items, the batch bundling approach does not handle the uneven workload well.
C. Correct: The top picking approach handles multiple records and handles uneven workloads well.

Related Topic: Performance Optimization

Module 14: Database Manipulation - Quiz

You are to complete the code needed to read records. Which will best complete this statement? While _________ fmVehicleMaint join fmVehicle

You 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(); _________________ }

You are to complete the code needed to update records. Which will best complete this statement? while select _______ fmVehicle

You are to complete the code needed to update records. You would like find the equivalent value. Which will best complete this statement? where fmVehicle.dbVehicleID ________ 1

You are to complete the code needed to update records. You need to assign the updated value for the vehicle model before updating. Which will best complete this statement? { fmVehicle.dbModel _______ "Big Truck"; fmVehicle.update(); }

You are to complete the code needed to delete records. Which will best complete this statement? { fmVehicle.________(); }

13. TRUE or FALSE. When performing a data insert, the insert() command inserts the contents of a table buffer.

The Update command modifies existing data in a table with the contents of a table buffer. TRUE OR FALSE?

You need to run a process in parallel. There are around 1,000 work items that would need to run with a bundle size of 100. You know that the run time for each work item will vary. What approach should you take to run this process?

You are to complete the code needed to read records. Which will best complete this statement?

You 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?

You are to complete the code needed to update records. Which will best complete this statement?

You are to complete the code needed to update records. You would like find the equivalent value. Which will best complete this statement?

You are to complete the code needed to update records. You need to assign the updated value for the vehicle model before updating. Which will best complete this statement?

You are to complete the code needed to delete records. Which will best complete this statement?