nerdexam
Oracle

1Z0-160 · Question #65

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

The correct answer is B. You must use port 1521 and the TCPS communication protocol. 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 Username: enter SYSTEM. Password: enter Pa55_WoRd. Hostname: enter the Public IP address…

Security for Database Cloud Service

Question

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

Options

  • AYou start an SSH process on your local machine to communicate to a tunnel created on the
  • BYou must use port 1521 and the TCPS communication protocol.
  • CYou can use only the SSH connection that is defined on port 22 that is configured by default during
  • DYou must use Transparent Data Encryption (TDE) to secure connections to the DBaaS database

How the community answered

(34 responses)
  • A
    12% (4)
  • B
    76% (26)
  • C
    3% (1)
  • D
    9% (3)

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 Username: enter SYSTEM. Password: enter Pa55_WoRd. Hostname: enter the Public IP address of the compute node associated with the database To find out this address, display details of the service as described in Viewing Detailed Information for a Database Deployment Port: enter 1521. SID: enter ORCL. 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-database-cloud-

Topics

#SQL*Net#TCPS#port 1521#network connectivity

Community Discussion

No community discussion yet for this question.

Full 1Z0-160 Practice