Module 14: Database Manipulation - Quiz

Q: You need to output a value to the screen. Which will best complete this statement?


_________(Int2Str(fmVehicleMaint.dbVehicleID)+', '+fmVehicle.dbMake);

A. info::box
B. info
C. warning
D. pause

Correct Option: B
Remarks:

Explanation:

Justification:

“Info::box” is not a valid output statement.
The info keyword is used to output the value(s) to the screen in an informational display format
The warning keyword will create a warning output message.
The pause keyword is not supported in Dynamics AX.

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 insert a given record. Which will best complete this statement?


fmVehicle.______________

A. insertRecord();
B. insertAll();
C. insert();
D. insertnow():

Correct Option: C
Remarks:

Explanation:

Justification:

insertRecord is not a valid method call.
InsertAll is not a valid method call.
The insert method is the correct method to call to insert a record or records into the table that the method is being called on.
InsertNow is not a valid method call.

Related Lesson: Data Insert

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 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: What are the three keywords associated with the Transaction Tracking System?

A. ttsBegin
B. ttsCommit
C. ttsAbort
D. All

Correct Option: D
Remarks:

Explanation:

Justification:

ttsBegin- You mark the beginning of the transaction with ttsbegin.
ttsCommit - You mark the successful end of a transaction with a ttscommit.
ttsEnd is not a valid command for the transaction tracking system.
ttsCommence is not a valid command for the transaction tracking system.
ttsAbort - This can be used as an exception to make a transaction be aborted and rolled back to its state before the ttsbegin. You insert a ttsAbort wherever you want this to occur.

Related Lesson: Transaction Integrity Checking

Q: You must fetch data from CustTable in ascending order based on City. CustTable contains a field named City. There is a non-unique cluster index named cityIdx on the City field. What are three possible statements that achieve the goal?

A. Select custTable index cityIdx;
B. Select custTable order by city;
C. Select custTable order by city ASC;
D. All

Correct Option: D
Remarks:

Explanation:

Justification:

This statement will select all records from the CustTable organized by the index titled cityIdx, which is configured on the custTable.
This statement selects all records from the custTable and specifies the “city” field in the table to order by. The default direction order by is ascending order.
This statement selects all records in the CustTable and specifies to order by the city field in ascending order. This is the same as the default order. The order by clause will default to ascending order if none is specified as well.
This statement will not work because the index name is not city, but cityIdx.

Related Lesson: Data Retrieval

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 are writing a query to retrieve the customers that are not associated with a sales order. What join between the Customer table and the Sales table should you use?

A. Join
B. Outer join
C. Exists join
D. NotExists join

Correct Option:
Remarks:

Explanation:

A. Incorrect: A join would return customer data and sales order data where the customer was associated with a sales order.
B. Incorrect: An outer join would return customer data and sales order data regardless of an association between them.
C. Incorrect: An exists join would return customer data for customers who are associated with a sales order.
D. Correct: A notExists join would return customer data for customers who are not associated with a sales order.

Related Topic: Performance Optimization

Module 14: Database Manipulation - Quiz

You need to output a value to the screen. Which will best complete this statement? _________(Int2Str(fmVehicleMaint.dbVehicleID)+', '+fmVehicle.dbMake);

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 insert a given record. Which will best complete this statement? 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 delete records. Which will best complete this statement? { fmVehicle.________(); }

What are the three keywords associated with the Transaction Tracking System?

You must fetch data from CustTable in ascending order based on City. CustTable contains a field named City. There is a non-unique cluster index named cityIdx on the City field. What are three possible statements that achieve the goal?

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

You are writing a query to retrieve the customers that are not associated with a sales order. What join between the Customer table and the Sales table should you use?

You need to output a value to the screen. 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 insert a given record. 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 delete records. Which will best complete this statement?