How would you connect from your local machine to the database instance on the DBaaS
server by using SQL*Net?
A.
You start an SSH process on your local machine to communicate to a tunnel created
onthe DBaaS server.
B.
You must use port 1521 and the TCPS communication protocol.
C.
You can use only the SSH connection that is defined on port 22 that is configured by
default during DBaaS instance installation.
D.
You must use Transparent Data Encryption(TDE) to secure connections to the DBaaS
database instance when using SQL*Net connections from your local machine to DBaaS
database instances.
Explanation:
To confirm remote access to the database through the SQL*Net security rule, create a
connection to the database in Oracle SQL Developer. When creating the connection, fill out
the fields as follows:
After entering values, click Test to test the connection.
Note: TCPS is TCP/IP with SSL.
Using Oracle Database Cloud Service (February 2017), 4-24
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-databasecloud-service.pdf
A
A
To create an Oracle Net connection when the listener port is blocked, you must create an SSH tunnel from your client (localhost) to the port of the compute node hosting the Oracle Net Listener.
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
A
1521 is default but we can change the port so B is not correct
A
A
To create an Oracle Net connection when the listener port is blocked, you must create
an SSH tunnel from your client (localhost) to the port of the compute node hosting the
Oracle Net Listener.
A