OUTSYSTEMS WEEK 9 EXAM QUESTIONS
WITH 100% VERIFIED CORRECT
ANSWERS!!
The On Click properties allow defining the behavior of Links and Buttons and ...
Users can interact with the application clicking or tapping Links and Buttons. This triggers an
action, submit data or navigate to another screen.
What's the correct screen lifecycle order after clicking a Button with the Navigate method?
After clicking the button, the server processes the Preparation of the destination screen to prepare
the data to be rendered on the browser.
Ending a Screen Action with an End element or a Destination to the '(Current Screen)'
yields the same result?
False. Yep! While the End preserves the values of Screen Variables and Widgets, the Destination
resets them to their defaults.
When doing a "With or Without" join between two entities, it returns ...
"A Customer With or Without Orders" corresponds in SQL to a "...Customer LEFT JOIN
Order..."
When columns are hidden in an Aggregate...
Hiding columns doesn't impact the output of the aggregate. However, OutSystems optimizes
which columns are fetched based on the output attributes being used outside the query.
When using an aggregate function like Sum, Average, Min, Max, or Count on an attribute
...
When aggregating attributes, the Aggregate changes its output, and only returns the computed
aggregated columns.
You can visually validate all attributes that are part of the Aggregate output because they appear
in blue.
, Building Data Relationships
Data types are rarely isolated
● A rich data model establishes the relationships between data
● The Relationships can be as important as the data itself
Entity Identifier
An Entity must have an Identifier to allow relationships
● Id attribute is a long integer and automatically numbered by default
● Mandatory
● Possible types
○ Text
○ Integer / Long Integer
○ (Another) Entity Identifier
Represents the database table's Primary Key
● OutSystems support simple primary keys
● NO composite keys
Referencing Data
- Entities can be referenced by their identifier
○ Create an attribute of type Entity Identifier
○ Can be mandatory or not
○ Static Entities can only reference other Static Entities
- Represents the database table's Foreign Key
● NullIdentifier() is the default value for reference attributes
1-to-1 Relationship
1-to-1
● Each Receipt belongs to one Order
● Each Order has at most one Receipt
- OrderReceipt is an extension of Order
● OrderReceipt has an identifier of type
WITH 100% VERIFIED CORRECT
ANSWERS!!
The On Click properties allow defining the behavior of Links and Buttons and ...
Users can interact with the application clicking or tapping Links and Buttons. This triggers an
action, submit data or navigate to another screen.
What's the correct screen lifecycle order after clicking a Button with the Navigate method?
After clicking the button, the server processes the Preparation of the destination screen to prepare
the data to be rendered on the browser.
Ending a Screen Action with an End element or a Destination to the '(Current Screen)'
yields the same result?
False. Yep! While the End preserves the values of Screen Variables and Widgets, the Destination
resets them to their defaults.
When doing a "With or Without" join between two entities, it returns ...
"A Customer With or Without Orders" corresponds in SQL to a "...Customer LEFT JOIN
Order..."
When columns are hidden in an Aggregate...
Hiding columns doesn't impact the output of the aggregate. However, OutSystems optimizes
which columns are fetched based on the output attributes being used outside the query.
When using an aggregate function like Sum, Average, Min, Max, or Count on an attribute
...
When aggregating attributes, the Aggregate changes its output, and only returns the computed
aggregated columns.
You can visually validate all attributes that are part of the Aggregate output because they appear
in blue.
, Building Data Relationships
Data types are rarely isolated
● A rich data model establishes the relationships between data
● The Relationships can be as important as the data itself
Entity Identifier
An Entity must have an Identifier to allow relationships
● Id attribute is a long integer and automatically numbered by default
● Mandatory
● Possible types
○ Text
○ Integer / Long Integer
○ (Another) Entity Identifier
Represents the database table's Primary Key
● OutSystems support simple primary keys
● NO composite keys
Referencing Data
- Entities can be referenced by their identifier
○ Create an attribute of type Entity Identifier
○ Can be mandatory or not
○ Static Entities can only reference other Static Entities
- Represents the database table's Foreign Key
● NullIdentifier() is the default value for reference attributes
1-to-1 Relationship
1-to-1
● Each Receipt belongs to one Order
● Each Order has at most one Receipt
- OrderReceipt is an extension of Order
● OrderReceipt has an identifier of type
