MB6-821 Free Dumps Study Materials
Question 15: Which select statement is identical to the Query object produced by the following block of code?
Query q;
QueryBuildDataSource qbDS;
QueryBuildRange qbR;
;
q = new Query();
qbDS = q.addDataSource(tableNum(InventTrans));
qbDS.addSelectionField(fieldNum(InventTrans,Qty),SelectionField::Sum);
qbDS.orderMode(OrderMode::GroupBy);
qbR = qbDS.addRange(fieldNum(InventTrans, ItemId)).value(SysQuery::value(""OL-2500""));
qbDS = qbDS.addDataSource(tableNum(InventDim));
qbDS.orderMode(OrderMode::GroupBy);
qbDS.addSortField(fieldNum(InventDim, InventBatchId));
qbDS.relations(true);
A.while select sum(qty) from inventTranswhere inventTrans.ItemId ==OL-2500join inventDimgroup by
inventBatchIdwhere inventDim.InventDimId == inventTrans.InventDimId
B.while select inventTranswhere inventTrans.ItemId ==OL-2500join inventDimgroup by
inventBatchIdwhere inventDim.InventDimId == inventTrans.InventDimId
C.select sum(qty) from inventDimgroup by inventBatchIdjoin inventTranswhere inventTrans.InventDimId
== inventDim.InventDimId&& inventTrans.ItemId ==OL-2500
D.while select sum(qty) from inventDimgroup by inventBatchIdjoin inventTranswhere
inventTrans.InventDimId == inventDim.InventDimId&& inventTrans.ItemId ==OL-2500
Correct Answer: a