Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

There are two correct answers.

It is expressed in terms of database tables and columns in SAP Commerce

Its query will not go through the cache

It allows nearly every feature of SQL SELECT statements

It is an out-of-the-box query language using an SQL-based syntax

There are two correct answers.

When comparing date values, truncate them to use caching of flexible search results

Directly use model attribute names and type names in flexible search queries

It’s better to select PK to query 'whole items', rather than arbitrary attributes

Use pagination via API to improve security

There are two correct answers.

For one-to-many relation, you should know the column name of the 'many' side table

For many-to-many relation, you don’t need to mention the relation in your flexible search query

For many-to-many relation, you must determine which related type is the sourceElement and which one is the targetElement

For one-to-many relation, you don’t need to mention the relation in your flexible search query

There are two correct answers.

ASC

DISTINCTED

COMBINE