MENDIX ADVANCED CERTIFICATION - LEARNING
PATH TESTS | FROM QUESTION TO PERFECTION|
STUDY WITH CONFIDENCE!
Data querying
Which operation can be used to select a specific set of rows in a table?
-set operation
- projection
- elimination
- selection - answer: selection
Data querying
The set union operation combines two lists into one that contains:
- all elements from both lists.
- all elements that exist in both lists.
- all elements that appear in only one of the two lists.
- all elements from both lists without duplicates. - answer: all elements from both lists
without duplicates.
Data querying
What operation combines the data from two different entities into one table?
- cartesian product
- set difference
- set union
- projection - answer: cartesian product
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,Data querying
What does the projection operation do?
- it allows you to add two lists into one.
- it allows you to project an entity onto a data view.
- it allows you to select attributes for all objects.
- it allows you to select objects from an entity. - answer: it allows you to select attributes for
all objects.
Constraint functions
What can you use a constraint function for?
- to select objects based on enumerations.
- to call a microflow into your xpath.
- to filter on strings and dates in xpath queries.
- to use java in your xpath queries. - answer: to filter on strings and dates in xpath queries.
Constraint functions
Question 2:
Which of the queries below can be used to filter on dates two weeks in the past?
- [%currentday%] - 2 * [%weeklength%]
- [%beginofcurrentday%] - 2 + [%weeklength%]
- [%currentday%] - 2 + [%weeklength%]
- [%beginofcurrentday%] - 2 * [%weeklength%] - answer: [%beginofcurrentday%] - 2 *
[%weeklength%]
Constraint functions
One of your xpath queries that use the contains() function is not performing very well. What
is the most likely root cause?
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, - you are using the function on an attribute that is not a string.
- you have implemented a custom function in javascript.
- you have not implemented a separate xpath query for all the languages that - your app is
using.
- you are using the function on a string that is set to 'unlimited'. - answer: you are using the
function on a string that is set to 'unlimited'.
Logical operators
When using the or operator:
- simply place the word 'or' between two xpath statements.
- 'or' must be the first word in the xpath expression.
- you must enclose the statement following the 'or' in ().
- you can omit the word 'or' and instead enter two separate xpath statements, each with its
own set of []. - answer: simply place the word 'or' between two xpath statements.
Logical operators
The not() function:
- cannot be used when you use the or operator.
- generates a slow query.
- can only be used on boolean attributes.
- generates the same query as the != operator. - answer: generates a slow query.
Optimization
Which statement best describes how you would retrieve all related objects in the most
optimal way?
- you can only compare an object to the id attribute of an entity of the same type to get the
most optimal query.
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
PATH TESTS | FROM QUESTION TO PERFECTION|
STUDY WITH CONFIDENCE!
Data querying
Which operation can be used to select a specific set of rows in a table?
-set operation
- projection
- elimination
- selection - answer: selection
Data querying
The set union operation combines two lists into one that contains:
- all elements from both lists.
- all elements that exist in both lists.
- all elements that appear in only one of the two lists.
- all elements from both lists without duplicates. - answer: all elements from both lists
without duplicates.
Data querying
What operation combines the data from two different entities into one table?
- cartesian product
- set difference
- set union
- projection - answer: cartesian product
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,Data querying
What does the projection operation do?
- it allows you to add two lists into one.
- it allows you to project an entity onto a data view.
- it allows you to select attributes for all objects.
- it allows you to select objects from an entity. - answer: it allows you to select attributes for
all objects.
Constraint functions
What can you use a constraint function for?
- to select objects based on enumerations.
- to call a microflow into your xpath.
- to filter on strings and dates in xpath queries.
- to use java in your xpath queries. - answer: to filter on strings and dates in xpath queries.
Constraint functions
Question 2:
Which of the queries below can be used to filter on dates two weeks in the past?
- [%currentday%] - 2 * [%weeklength%]
- [%beginofcurrentday%] - 2 + [%weeklength%]
- [%currentday%] - 2 + [%weeklength%]
- [%beginofcurrentday%] - 2 * [%weeklength%] - answer: [%beginofcurrentday%] - 2 *
[%weeklength%]
Constraint functions
One of your xpath queries that use the contains() function is not performing very well. What
is the most likely root cause?
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, - you are using the function on an attribute that is not a string.
- you have implemented a custom function in javascript.
- you have not implemented a separate xpath query for all the languages that - your app is
using.
- you are using the function on a string that is set to 'unlimited'. - answer: you are using the
function on a string that is set to 'unlimited'.
Logical operators
When using the or operator:
- simply place the word 'or' between two xpath statements.
- 'or' must be the first word in the xpath expression.
- you must enclose the statement following the 'or' in ().
- you can omit the word 'or' and instead enter two separate xpath statements, each with its
own set of []. - answer: simply place the word 'or' between two xpath statements.
Logical operators
The not() function:
- cannot be used when you use the or operator.
- generates a slow query.
- can only be used on boolean attributes.
- generates the same query as the != operator. - answer: generates a slow query.
Optimization
Which statement best describes how you would retrieve all related objects in the most
optimal way?
- you can only compare an object to the id attribute of an entity of the same type to get the
most optimal query.
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
