Oracle Cloud Infrastructure 2019 Cloud Operations Associate — Question 20

How would you connect from your local machine to the database instance on the DBaaS server by using SQL*Net?

Answer options

• A. You start an SSH process on your local machine to communicate to a tunnel created on the 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

Correct answer: B

Explanation

The correct answer is B because SQL*Net connections to Oracle databases typically use port 1521 with TCPS for secure communication. Answer A is incorrect as it describes an SSH tunnel, which is not the primary method for a direct SQL*Net connection. Option C is wrong because while SSH is on port 22, it does not pertain to SQL*Net connections. Option D is misleading since TDE is for data encryption at rest and does not directly relate to connection protocols.