ACSCE-5X practice question 15 of 15

Which function can be used in the SELECT clause of a CMIS query to return a measure of the relevance of each row, in numerical format?

Full set: 87 questions
Answer options
A: VALUE()
B: POS()
C: RANKING()
D: SCORE() Correct answer
Correct Answer:
D. SCORE()
Explanation

The SCORE() function is the standard function defined by the Content Management Interoperability Services (CMIS) specification to be used in the SELECT clause of a query. Its purpose is to return a numerical relevance score for each result row. This function is specifically designed to work in conjunction with the CONTAINS() predicate in the WHERE clause, which executes a full-text search. The returned score indicates how relevant each document is to the search criteria, allowing applications to rank or filter results accordingly.

Why Incorrect

A. VALUE() is not a standard CMIS function for returning a relevance score.
B. POS() is not a standard CMIS function and is not used for relevance scoring.
C. RANKING() is not a standard CMIS function for relevance scoring.

References

1. OASIS Content Management Interoperability Services (CMIS) Version 1.1. (23 May 2013). OASIS Standard.

Section 2.2.6.3.2.5 Functions: "The SCORE() function MAY be used in the SELECT list. This function returns a relevance score for each row, if the WHERE clause contains a CONTAINS() predicate. The values are numerical and greater than or equal to 0.0. A larger value indicates a better match."

2. Alfresco Content Services 5.2 Documentation.

Alfresco Full Text Search Reference > Search query syntax > CMIS query: The documentation details the use of CMIS-SQL for queries and confirms adherence to the CMIS standard, which includes the SCORE() function. An example query is often shown as: SELECT d., SCORE() FROM cmis:document AS d WHERE CONTAINS(d, 'search-term') ORDER BY SCORE() DESC. This explicitly demonstrates the function's usage for retrieving relevance.

Scroll to Top