Which three are true about using REST Enabled SQL to access a remote database? (Choose three.)
Click on the arrows to vote for the correct answer
A. B. C. D. E. F.BDE.
https://docs.oracle.com/database/apex-18.1/HTMDB/rest-enabled-sql-creating.htm#HTMDB-GUID-0906921E-AF79-49D4-B909-1C090F805D9DREST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables users to execute SQL statements against a remote Oracle database via RESTful Web Services. The following are the three true statements about using REST Enabled SQL to access a remote database:
B. REST Enabled SQL must be enabled in the remote databases' ORDS configuration. To use REST Enabled SQL, it must be enabled in the ORDS configuration of the remote database. This can be done by setting the "restEnabledSql.enabled" parameter to "true" in the ORDS configuration file (defaults.xml).
C. A wallet must be defined and configured on the remote database. To establish a secure connection between the remote database and the client application, a wallet must be defined and configured on the remote database. The wallet contains the SSL/TLS certificates and keys required to authenticate the client and encrypt the data in transit.
D. A REST Enabled SQL Reference must be created in Shared Components. To use REST Enabled SQL in an Oracle Application Express (APEX) application, a REST Enabled SQL reference must be created in the Shared Components section of the application. This reference contains the endpoint URL, SQL statement, bind variables, and other configuration details required to execute the SQL statement via RESTful Web Services.
Therefore, options B, C, and D are true about using REST Enabled SQL to access a remote database. Options A, E, and F are false because authentication can be done using a remote database username and password, OAuth2 Client Credentials flow is not mandatory, and the application parsing schema does not need to be REST enabled to use REST Enabled SQL.