Oracle SOA Suite 12c Essentials — Question 20

Which two statements are true about the role of a Continuous Query Language (CQL) processor in a Oracle Event Processing application?

Answer options

• A. It primarily executes SQL statements against the database.
• B. It can be used to filter, aggregate, and correlate events in memory and can integrate with Coherence, NoSQL, and HDFS.
• C. It invokes human workflows to deal with exception handing.
• D. It can perform spatial queries as well as complex

Correct answer: C, D

Explanation

The correct answers, C and D, indicate that the CQL processor is involved in managing human workflows for exceptions and can handle both spatial and complex queries. Options A and B are incorrect as they misrepresent the primary functions of the CQL processor, which focuses on event processing rather than standard SQL execution or just filtering and aggregating events.