Oracle 1z0-160 Exam Practice Questions (P. 4)
- Full Access (70 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #16
Oracle provides additional web-based tools for monitoring Database as a Service (DBaaS) instances. One of the tools is DBaaS Monitor Console.
Which user would you have to log in as to use this tool?
Which user would you have to log in as to use this tool?
- Adbsnmp
- Bsys
- Cdbaas_monitor
- Dsysman
Correct Answer:
C
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:
1. Open the Oracle Database Cloud Service console.
2. From the menu for the deployment, select Open DBaaS Monitor Console.
A window prompting you for your user name and password is displayed.
3. Enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK.
References: Using Oracle Database Cloud Service (February 2017), 10-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
C
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:
1. Open the Oracle Database Cloud Service console.
2. From the menu for the deployment, select Open DBaaS Monitor Console.
A window prompting you for your user name and password is displayed.
3. Enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK.
References: Using Oracle Database Cloud Service (February 2017), 10-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
send
light_mode
delete
Question #17
How would you connect from your local machine to the database instance on the DBaaS server by using SQL*Net?
- AYou start an SSH process on your local machine to communicate to a tunnel created on the DBaaS server.
- 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 DBaaS instance installation.
- DYou 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
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:
✑ Username: enter SYSTEM.
✑ Password: enter Pa55_WoRd.
✑ Hostname: enter the Public IP address of the compute node associated with the database deployment. 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.
References: Using Oracle Database Cloud Service (February 2017), 4-24 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
B
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:
✑ Username: enter SYSTEM.
✑ Password: enter Pa55_WoRd.
✑ Hostname: enter the Public IP address of the compute node associated with the database deployment. 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.
References: Using Oracle Database Cloud Service (February 2017), 4-24 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
send
light_mode
delete
Question #18
How do you enable a default connection between Database as a Service (DBaaS) instances?
- Aby creating network groups and adding the instances that you want to communicate to that group
- Bby creating dedicated communication keys and setting them to be used only for your DBaaS instance-to-instance communication
- Cby creating nothing for communication between the DBaaS instances because all instances are interconnected by default
- Dby installing and configuring the NETMGR utility for your DBaaS environment, and then using it to set up the required communication channels
Correct Answer:
B
Before your DBaaS database was created, you or a coworker generated a private and public SSH key pair, perhaps using PuTTY Key Generator.
The public key was specified when your database instance was created; a copy of that public key was stored in the VM hosting your database.
When you define in PuTTY an SSH connection to the VM hosting your database, you will specify a copy of the private key stored on your local PC. When you initiate a PuTTY connection, the VM compares the private key to the matching public key stored in the VM. The VM permits the connection when the private and public key match as a valid key pair.
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_connecting_to_an_instance/ obe_dbaas_connecting_to_an_instance.html
B
Before your DBaaS database was created, you or a coworker generated a private and public SSH key pair, perhaps using PuTTY Key Generator.
The public key was specified when your database instance was created; a copy of that public key was stored in the VM hosting your database.
When you define in PuTTY an SSH connection to the VM hosting your database, you will specify a copy of the private key stored on your local PC. When you initiate a PuTTY connection, the VM compares the private key to the matching public key stored in the VM. The VM permits the connection when the private and public key match as a valid key pair.
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_connecting_to_an_instance/ obe_dbaas_connecting_to_an_instance.html
send
light_mode
delete
Question #19
You are on the Database Cloud Service Instance View page.
Which three consoles can you open?
Which three consoles can you open?
- AOPC Console
- BGlassFish Administration Console
- CStorage Container Console
- DApplication Express Console
- EUser Console
- FDatabase Express Manager Console
Correct Answer:
DEF
DF: The menu for each deployment that provides the following options:
✑ Open DBaaS Monitor Console Open the Oracle Cloud Database Monitor for the deployment.
✑ Open Application Express Console Open the Oracle Application Express home page for the deployment.
✑ Open EM Console Open the database console, either Enterprise Manager Database Express 12c or Enterprise Manager 11g Database Control.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
DEF
DF: The menu for each deployment that provides the following options:
✑ Open DBaaS Monitor Console Open the Oracle Cloud Database Monitor for the deployment.
✑ Open Application Express Console Open the Oracle Application Express home page for the deployment.
✑ Open EM Console Open the database console, either Enterprise Manager Database Express 12c or Enterprise Manager 11g Database Control.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
send
light_mode
delete
Question #20
What are two ways to enable a port on your DBaaS VM server for access to your DBaaS instance?
- AUse your public and private key pairs to define a list of preferred ports that get enabled during your DBaaS instance installation.
- BCreate a tunnel for port forwarding by using SSH.
- CConfigure all remote connections through port 22 that is assigned by default for SSH connections.
- DAsk Oracle DBaaS Support to open the required ports.
- EUse the DBaaS Compute Cloud Service Console to open ports to a set of IP addresses.
Correct Answer:
BC
C: SSH is a cryptographic network protocol that uses two keys, one public and one private, to provide secure communication between two networked computers.
Port 22 is the standard TCP/IP port that is assigned to SSH servers.
B: To access network protocols and services on a compute node by using a port other than port 22, you must either:
- Enable network access to the port
You can use the Oracle Database Cloud Service console to enable access to a port on a compute node.
- Create an SSH tunnel to the port
Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you must have the SSH private key file that matches the public key specified during the database deployment creation process.
References: Using Oracle Database Cloud Service (February 2017), 3-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
BC
C: SSH is a cryptographic network protocol that uses two keys, one public and one private, to provide secure communication between two networked computers.
Port 22 is the standard TCP/IP port that is assigned to SSH servers.
B: To access network protocols and services on a compute node by using a port other than port 22, you must either:
- Enable network access to the port
You can use the Oracle Database Cloud Service console to enable access to a port on a compute node.
- Create an SSH tunnel to the port
Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you must have the SSH private key file that matches the public key specified during the database deployment creation process.
References: Using Oracle Database Cloud Service (February 2017), 3-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
send
light_mode
delete
All Pages