On the following link :
You can find a Data sheet that contains several information regarding Oracle Database Cloud Service.
There, it is stated that one of the features ( among others) of Oracle Cloud Database service is :
--Full capabilities of the Oracle Database, including SQL and PL/SQL support
Please read the document, and let us know if this anwers your question.
Thank you for your interest in our Oracle Cloud Services.
I have further checked with my colleagues and they confirmed the following:
Oracle OLAP does not come as part of the Cloud.
the only option included with the Database Cloud is partitioning
In addition, in the initial GA release, materialized views are not supported, as we will have to limit the refresh rate on MVs to protect the performance integrity of the Database Cloud. We expect to lift this restriction in the near term, but there is no fixed date for the addition of other options.