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 questionsThe 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.
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.
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.
Keep practicing
Take the free ACSCE-5X practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ACSCE-5X practice questions
- Question 1Alfresco Content Services defines some root objects to use with Web Scripts FreeMarker te…
- Question 2You want to increase the maximum number of results returned by searches in Share from the…
- Question 3What does it mean when it is said in Solr indexing that the index is “eventually consiste…
- Question 4What are the minimum steps needed to add a custom search form in Alfresco Share?
- Question 5How should s be identified and recognized?
- Question 6What are the variable’s scopes available for Activiti workflows?
