Module 14: Database Manipulation - Quiz

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


fmVehicle.______________

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

Correct Option: C
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
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 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:
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

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
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 update the unit price of multiple sales orders. What method would be best to use?

A. Update()
B. doUpdate()
C. update_recordSet
D. insert_recordSet

Correct Option: C
Explanation:

A. Incorrect: The update method does not update multiple records without making multiple calls to the database.
B. Incorrect: The doUpdate method does not update multiple records without making multiple calls to the database.
C. Correct: The update_recordSet method updates multiple records with one call to the database and is the best method to use.
D. Incorrect: The insert_recordSet method will create new records, not update existing records.

Related Topic: Performance Optimization

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

Module 14: Database Manipulation - Quiz

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

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

You need to update the unit price of multiple sales orders. What method would be best to use?

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 read records. Which will best complete this statement? While _________ fmVehicleMaint join fmVehicle

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

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 need to output a value to the screen. Which will best complete this statement?

You are to complete the code needed to read records. 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 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?